Graphs, charts and other graphical methods for showing data and their relationships.

**1**

vote

**1**answer

1k 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

761 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

3k 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

449 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

10k 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

18k 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

60k 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

739 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

623 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

236 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

376 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

22k 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

1k 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

230 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

424 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

3k 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

4k 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

422 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

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

**8**

votes

**4**answers

24k 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

3k 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

995 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

1k 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

3k 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

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

**11**

votes

**2**answers

99k 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

775 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

136 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

747 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

56 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

702 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

9k 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

225 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

4k 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

273 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

389 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

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

**1**

vote

**2**answers

11k views

### Excel bar chart - how to make axis as time scale

My data has column 1 = date (date format), column 2 = quantity (number format). The data looks like:
date qty
1/3/2010 5
2/3/2010 2
2/4/2010 3
2/9/2010 1
4/13/2010 5
5/31/2010 5
...

**2**

votes

**1**answer

668 views

### Plotting the volume of an audio file

Most applications that play sound display its volume graphically. I need that information (the sound volume as it changes over time) written to a text file so I can plot it myself and use it for ...

**1**

vote

**1**answer

446 views

### How can I turn data below in to a 'time based' graph

In my spreadsheet I am collecting time periods when certain values have been changed. The user is restricted to 4 time periods. I would like to show the data based on those time periods.
I've ...

**1**

vote

**2**answers

1k views

### Excel 2007 Pivot Tables: Overlapping issue hampers my summary sheet

I've created a Workbook that has 5 Pivot Tables (PT). I want to make a summary sheet that holds all these PT's, but when they expand the 'not allowed to overlap issue' causes me updating problems - ...

**0**

votes

**1**answer

675 views

### Graph plotting software that includes the min() and max() functions

I am looking for online or offline software that can plot functions that include min() and max(). Neither of my favourites, Wolfram Alpha and fooplot seem to have these functions built in :-(

**0**

votes

**1**answer

1k views

### Timeline chart in Excel

I'd like to see a timeline of events from a database in a "timeline chart", that should look like this:
I've made me a small c# program that paints this onto a Bitmap, but that isn't the way to ...

**1**

vote

**2**answers

925 views

### How to get scrolling plot in Linux (using command-line tools)?

Supposing I have a program that prints lines with data periodically, how can I turn then info them into graphical plot that updates itself each time new line available?
$ ./prog
10 44
20 66
30 55
40 ...