Help on questions about graphs, charts and other graphical methods to show data.

learn more… | top users | synonyms (1)

1
vote
2answers
3k views

Excel: How to create a chart that automatically scales the axis

I have 2 columns with values, say A and B which values I want to use as X and Y axes values correspondingly. The values are the following: A: 412 684 944 2009 9601 B: 7813,4 10377,6 11138,8 16216 ...
1
vote
1answer
612 views

Generate a point chart from XML data, possibly with Excel?

I would like to generate some point chart from XML data. The data should be grouped using color by its "id" attribute. The position is stored in "x" and "y". What software should I use? I tried Excel ...
4
votes
3answers
25k views

Making line charts so the line goes through all data points

I've got data based on over 50+ years for various products. Not all products have data for each year, so the line is not always shown from point to point - Excel bug or is there a work around? I've ...
0
votes
3answers
2k views

Annotating Graphs From Textual Data

I have a graph that was generated from a data set that contains: (date, value, annotation) The annotation is a constant value [its either there or is blank] and I would like to add in the third ...
1
vote
1answer
792 views

Excel Chart not displaying X Axis

I've got a chart in a spreadsheet in Excel 2010 which is using A chart = "Stacked Column in 3-D" I have defined the Horizontal (Category) Axis Label in the Select Data Source window and it is ...
1
vote
1answer
4k views

Prevent Excel Chart Data Labels overlapping

I have an Excel dashboard with line charts containing data labels. Specifically, we are only using the data labels at the rightmost end of the lines, and the labels consist of the Series name and ...
0
votes
1answer
930 views

Line chart with very small difference in values

I have data in excel that basically looks something like this: x264 VP8 Theora 0.99593 0.99328 0.96688 0.99497 0.99243 0.96646 0.99442 0.99180 0.96680 ............. and so on for about 4500 ...
1
vote
1answer
947 views

Excel 2007 bar chart auto axis

I am creating a bar chart with values ranging from 100 to 100,000. I keep the X axis as auto scaling allowing me to change the starting point. From what I understand, if two bars variance is greater ...
0
votes
1answer
711 views

How can I prepare a pie chart in excel with a result based on 100%?

I have the total I've earned last year which should represent the 100% of the pie. Then I have my insurance expenses and I want to understand, graphically, how much of my total income went to pay ...
0
votes
1answer
2k views

Excel 2010: Create Graph From List

I have created a drop down list for use in each row (for the purpose of categorising). I'd like to graph the selected data (i.e the column of drop down lists) into a graph, probably a pie chart. If I ...
1
vote
2answers
400 views

Grapher: Edit Equations Without GUI

I'm trying to edit the equation of a Grapher file without opening the Grapher UI. I've gotten as far as knowing that I need a hex editor to do this. I can't, however, find my equation in that file to ...
1
vote
2answers
6k views

Excel - Chart that sums the values in multiple rows for each series

Suppose I have a spread sheet that looks something like this... Now, I'd like to create a column chart that has 3 series, one for each country. Then, I want series for each category, but I want to ...
0
votes
1answer
2k views

Excel 2010: How to color the area between charts?

I asked this question already on stackoverflow but it hasn't been answered yet. Instead I was advised to try it here, so here I go :) So there's that simple XY-Line-Chart in Excel (2010). It is ...
1
vote
4answers
15k views

How to create a Wind Rose plot in Excel 2007?

I am attempting to create a wind rose graph, i.e. My data is wind speed and cardinal wind direction in separate columns: Wind (mph) Wind Direction 3.66 SE 2.69 SE 2.62 SW ...
6
votes
4answers
40k views

How to change x-axis min/max of Column chart in Excel?

Here i have a column chart of binomial distribution, showing how many times you can expect to roll a six in 235 dice rolls: Note: You could also call it a binomial mass distribution for p=1/6, ...
0
votes
2answers
629 views

interpolation chart in excel

My data is about real estate lots: area and price. The data is not sorted. How can I create a chart so that I can see the correlation between area and price? For example for: 500 1,000,000 450 ...
0
votes
1answer
597 views

PowerPoint 2010 Chart Arrows

Summary: I have a powerpoint slide that I created, that when played it changes the direction of the arrows. Detail: I created a chart using Excel 2010 (Windows 7). I copied the chart and pasted it ...
1
vote
0answers
223 views

Gantt chart drawing tool

I need a Gantt chart drawing tool but on timeline I need my custom units (e.q. from 0 to 3000), not days or years. What tool alows to do that? Edit: Finally I have found no such tools. I had to make ...
1
vote
2answers
2k views

Excel 2010, Consolidating Category Axis in Pie Chart

I am working on a very basic "home budget" spreadsheet, to quickly see: A) how much money is left after the bills are paid and B) what % of withdrawals are going to what categories of expenses. I ...
0
votes
1answer
365 views

How to create graphs in Excel 2007?

I have data in CSV format, and I want to create a few graphs. I was looking around in google for how to do that, but it seems like most help about Excel graphs does not match my version of Excel ...
3
votes
1answer
15k views

Excel 2010: Can I hide columns without excluding the data from a graph?

In Excel 2010, is it possible to hide columns but still have the values show up in a graph? I have a graph of monthly data going back to 2005, with each month's data in a column. If I hide the ...
1
vote
1answer
865 views

Excel graph: turn stacked bar chart into part bullet chart

I've a simple data file that has one column of actuals and another of target against categories. I would like to turn the TARGET figure into a 'Bullet marker'. I've seen it done on other graphs but ...
2
votes
2answers
212 views

Processing RAW data to make a web displayable graph

I have data on a Linux system, about 44K data points, that I'd like to make a Scatter plot. The plot should be saved so that it can be displayed on a website (JPG?). Some other parameters: X-Axis: ...
1
vote
2answers
381 views

Graphing connections per second in excel

I have an Excel 2010 file like so: date time connections 2010-10-18 08:20:00 38 2010-10-18 08:20:01 71 2010-10-18 08:20:02 67 I want a line graph with the number of connections as the y ...
4
votes
3answers
2k views

Creating map of countries colored using country statistics

I want to create a PNG (or GIF) image, with geopolitical map of countries, where each country has color set according to some country statistics (e.g. 'USA' has n, 'Canada' has m, etc.). Something ...
2
votes
2answers
2k views

Calculate the Y Axis interval for a chart

When creating a chart of, e.g. daily sales figures for the month. Does anyone know how to calculate a suitable Y Axis interval? I've been looking at Excel which seems to choose nice intervals like ...
2
votes
2answers
3k views

Placing labels on data points in a stacked bar chart in Excel

Is it possible to place the labels not on the Y axis, but on the data point itself in a stacked bar chart in excel? I am trying to modify the timeline template available here so that my labels for ...
1
vote
1answer
390 views

Tools to plot time-series data

I have a time-series dataset that looks like this (a few thousands of entries spanning for a couple of years): timestamp <TAB> items_added <TAB> items_removed For example: 1286016527 ...
5
votes
1answer
871 views

How to cancel tedious Excel charting operation without crash

I'm charting about 17,000 data points in Excel. Needless to say charting is slowwww. I accidentally selected the wrong chart type (Bubble thing?) and it is loading forever. I did not save my last ...
6
votes
4answers
18k views

Excel Scatter Chart with Labels

I have three columns of data. Column 1 has a short description, column 2 has a benefit number and column 3 has a cost. I can create a cost/benefit scatter chart, but what I want is to be able to ...
3
votes
3answers
2k views

Excel trendline accuracy

This is a problem I have every once in a while, and it annoys me tremendously, beacuse I have always to recheck every trendline I get. An example: r L (mm) 30,00 97,0 60,00 103,2 ...
2
votes
1answer
844 views

How do you set a variable Y-axis min/max?

I have a colleague who creates lots of charts. He wants the min/max of the Y-axis of a bar chart to reflect the min/max within a range in Column "A" of an Excel spreadsheet. The min/max will change ...
2
votes
2answers
930 views

Visualizing document citations in a graph

Is there any tool which draws a citation graph for a group of related papers? (it doesn't matter the format of papers - PDF, Word, etc - it also doesn't matter if the software doesn't perform parsing ...
3
votes
3answers
2k views

Excel Graph: how can I show two values in the same bar? Not using stacked?

I've created some data for inventory items over time. Each item has two models (A & B), and the scale is (-) or (+). I've included example images of the type of graph (drawn) I'm aiming for, with ...
1
vote
2answers
1k views

Excel charts in PowerPoint 2007 are not editable by PowerPoint 2003

I'm trying to save a PowerPoint 2007 presentation which includes a chart copied from an Excel 2007 sheet in 97-2003 format but the chart is no longer editable by Office 2003 since it's automatically ...
0
votes
1answer
211 views

Excel Formula: trouble with the low % values not showing up in an in-cell chart? (image included)

I've a few tables that have % values like -4.5%; -16%; 15%; 6%; 2.5%. I'm interested in creating some in-Cell charts that show positive and negative values. My smaller values aren't showing up, so ...
10
votes
2answers
67k views

Excel chart with two X-axes (horizontal), possible?

Is it possible to create an Excel chart which has two X-axes (i.e. horizontal axes, not vertical Y-axes!) ? I want to use the second axis to plot the normalized value of the default horizontal axis. ...
0
votes
1answer
652 views

Graphing Time in the Y-Axis creates duplicate entries?

I'm trying to create a graph based on Times and Dates and the Times on the Y-AXIS are being created with duplicate values. I attached a screenshot with the problem, the 0:00 can be seen twice. Does ...
0
votes
1answer
130 views

Trouble Making a Graph in Excel

I have two columns of data: Time Taken: 00:00:42.1093750, 00:00:09.5468750, 00:00:47.2656250, 00:01:27.6718750 Start Time: 21:02:27, 21:33:16, 22:03:27, 22:34:19 I want to make a cluster graph ...
3
votes
1answer
676 views

Excel 2007 Chart - Super Simple Chart what am I doing wrong?

I have two columns. The first column begins with "Year" followed by well years (1999, 2000, 2001, etc.). The second column has a title of "Revenue" and is contains revenue values ($12.1M, $13.2M, ...
1
vote
1answer
55 views

low-latency charting?

Need to deliver real-time charts (mostly bar and line charts) and wondering if a fast library can help. I guess that C is mandatory for speed and I would favor frame-buffer drawing (rather than a ...
2
votes
2answers
1k views

Excel: ROUND() to the next unit of 5?

I'm creating a lot of graphs, so I'm making a common scale to be able to compare them using MAX/MIN values that I'm hiding in the graph as a separate series. My Vertical AXIS (Y) is in units of 5. ...
1
vote
1answer
655 views

Excel graphs: MIN/MAX axis scaling isn't working correctly

I have lots of graphs which I need to compare against each other. Therefore, I need a common scaling along the vertical (Y) axis. I'm encountering problems when pasting in my MIN/MAX series, and then ...
2
votes
1answer
2k views

Excel graphs: How do I apply a graph template format?

I've created a format that I like. I now need to apply this format to over 900 graphs! I've seen we can save a format as a template for future use, however, I can't find the place where I have the ...
3
votes
5answers
7k views

Extract a graph legend and place it on the worksheet itself?

I have 8 graphs all with the same legend (line colours and meaning), so in order to save space I would like to remove the legend from each graph and create/include just one large one at the top of the ...
1
vote
2answers
216 views

What software created this graph?

Can anyone recognize what software could have been used to create a graph like this? I'm looking for something that could produce the same type of arrows.
3
votes
2answers
3k views

Excel: Pie Chart of a Question with Limited Possible Responses

I distributed a survey online and received the answers in an Excel spreadsheet. I would like to make a pie chart out of some of the closed option answers. For example, one of the questions was gender. ...
1
vote
1answer
238 views

Pie Chart in Excel

I tried to google this but no luck. It is easy to add a pie chart when you have prcentace data but what if you just have a list of partially repeated data? For simplicity imagine there is a table in ...
1
vote
0answers
376 views

How to plot this in iwork-numbers

I have an array of data like this 0,1 0,56 0,4 0,57 0,6 0,006 0,34 0,46 ... I have another array of data that classifies the data above in categories like this: from 0,1 to 0,5 category A from ...
1
vote
1answer
497 views

Is there a program to calculate fibonacci charts and their continuations?

I'd need a program able to take data and plot a trend graph, and it should be able to continue it to see the future trend. I've found some commercial programs but none work. Is there a free one? I ...