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

**1**

vote

**2**answers

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

**1**answer

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

**3**answers

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**4**answers

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

**4**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**3**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**4**answers

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

**3**answers

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

**1**answer

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

**2**answers

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

**3**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**5**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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 ...