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

**5**

votes

**1**answer

936 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

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

957 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

212 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

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

735 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

134 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

744 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

688 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

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

224 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

263 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

539 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

646 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

441 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

665 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

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

**3**

votes

**1**answer

8k views

### How to plot survey results on Excel?

I would like to plot the average of these data samples:
1. Contribution to the project
2. Affiliation with project owners
3. Level of expertise
4. Learning Curve
Yes No 3 2
No No 3 2
No ...

**5**

votes

**3**answers

71k views

### how to add an average line to the graph in excel 2007 or 2010

In OpenOffice I'm getting trend-line and average-line properties by RightClick. But in Excel 2007 I see only trend-line. Same with Excel 2010. How do you make an average-line in Excel?

**0**

votes

**2**answers

530 views

### Apart from visually inspecting the graph, is there a way of calculating when a trend line will cross another series?

Is there a way to find the point of intersection of a trend line and another series on a chart in Excel? The other series may be another trend line or just the interpolated line drawn by Excel.

**0**

votes

**1**answer

5k views

### Excel - add target line to stacked bar chart

I've got a stacked bar chart. I'm displaying a set of floating bars to represent hi/low ranges for some metrics, by using a transparent fill on the bottom section of the bar I achieve the desired ...

**0**

votes

**3**answers

3k views

### Relative Gantt in MS project?

Is there a way to create a relative Gantt in MS project, that is a Gantt that doesn't have a defined start date, just amount of time required for each task?

**0**

votes

**1**answer

114 views

### Customising error bars

I've been told I have to have custom error bars for an assignment I have to hand in.
Okay, I have a scatter graph with twelve points, and the error for each one is different. It's the same plus and ...

**3**

votes

**3**answers

719 views

### Fourier transform software [closed]

After spending a lot of time searching for this, I thought that some Super User gurus might know the answer. I'm searching for an open source application to compute a FFT, that could:
Import a ...

**1**

vote

**4**answers

13k views

### Is there a graph paper like drawing software?

I have a college assignment, where I have to draw diagrams of voronoi, delaunay, minimum spanning tree etc for the college. I want to do that in computer. I searched in google with no luck. Is there ...

**1**

vote

**2**answers

8k views

### Why can't I add a trendline to a chart in Excel 2007?

I created a really simple chart based on 2 columns (date and numeric value).
I click on the chart, go to Chart Tools/Layout. The Trendline drop down is greyed out.
What am I missing?

**2**

votes

**2**answers

6k views

### Graphing mean and standard deviation

I have measurements for multiple devices, and have their mean and sd values. I would like to produce a chart that would show these values, and I think the best would be if I could have something that ...

**6**

votes

**3**answers

14k views

### Excel chart on one column of date/times

I have a list of date/timestamps, and I would like to plot these to a chart in Excel. What I'm looking for is a chart that shows "events per hour" or something similar. Can this be done easily if I ...

**1**

vote

**1**answer

414 views

**1**

vote

**1**answer

14k views

### Prevent Excel from resizing graphs

When a row or column is inserted around a graph in Excel, Excel automatically resizes (expands) the graph. This corrupts the dimensions I determine for a specific graph. How can I prevent Excel from ...

**1**

vote

**1**answer

20k views

### Finding X on Excel scatter plot/trend line

If I have some data in an scatter plot in Excel, e.g.
X Y
1 10
2 20
3 30
4 40
5 50
and I want to find the Y value for X = 10, or X=3.5, or whatever (obviously this is a simplified example) I've ...

**2**

votes

**2**answers

519 views

### Best software to build charts (pies, bars) [closed]

I am somewhat disappointed with Excel charts and short of building my own with a vector graphics too, is there something really awesome for charts?

**2**

votes

**4**answers

5k views

### How to make bar graph shorter for higher numbers?

I would like to inverse the bar graph in a way that the lower the number, the higher the bargraph should be.
Currently in the picture below, those items ranked 200 have the highest bar height while ...

**2**

votes

**1**answer

9k views

### Create two axis stacked columns chart in Excel

The data I'd like to chart is like this:
2000 2001 2002
A x x x
B x x x
C x x x
D x ...

**1**

vote

**2**answers

60 views

### Is there a web site that allows you to draw an ascii chart with boxes and arrows easily?

Ascii drawings and charts are a useful way of documenting software and can be included directly in source files near the code they document.
I'm looking for an online tool to draw them and be able to ...

**3**

votes

**1**answer

10k views

### How do I divide one column in gnuplot?

I have gnuplot data file.
I would like to plot it, but divide every value in the x-axis by n.
Can I do this from within gnuplot, or do I have to rewrite the data file?

**1**

vote

**1**answer

611 views

### Excel 2003 charts not looking right in 2007

I'm not exactly sure this goes here but I don't know where else to look for help.
I have some Excel files containing charts made with Excel 2003. When I open the file in Excel 2007 and save it (non ...

**8**

votes

**7**answers

4k views

### How to easily plot graph, using (preferably) free software?

I need to plot a graph, given some data, where on X axis will be names of data and on Y axis those data, and it will be given by a table, and it will be line graph with the data connected. If there ...