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

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

736 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

674 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

256 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

385 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

529 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

641 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

440 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

656 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

865 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

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

504 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

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

413 views

**1**

vote

**1**answer

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

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

505 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

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

59 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

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

**3**

votes

**5**answers

338 views

### Any good 'how to…' resources out there? [closed]

Does any one have any good resources - websites or books, when it comes to creating (mastering) simple to complicated graphs or charts?
I've reached the point where I need to do more than tables. ...

**0**

votes

**4**answers

6k views

### My pivot chart has the wrong Y axis values but correct data point values

I created a pivot chart based on some raw data for the x axis (dates) and 4 calculated fields for the Y values.
The values on resulting lines are correct (see the data label at the end of the line) ...

**4**

votes

**4**answers

6k views

### How to create diagram in spreadsheet with dates on x-axis?

I recently became a father to twin boys. Naturally there is a lot of weighing and measuring, and we record these numbers in a spreadsheet. I use OpenOffice.org Calc (but I'm open to solutions for ...

**5**

votes

**2**answers

9k views

### Program for reading data off scanned graphs [closed]

I know such thing exists, cause I used it somewhat long ago ... problem being I cannot remember what it's called.
I have some graphs from which I need to read off points (numeric values). The graphs ...

**3**

votes

**4**answers

10k views

### Excel chart, how to make a formula produce gaps?

I have a chart in Excel 2007 that is basically just a line graph.
Some cells that make up the series data cannot produce a value through their formula, and I'd like the chart to place a gap in that ...

**0**

votes

**1**answer

400 views

### Cacti displaying graph text as blocks

(Image now irrelevant, it is grabbing the newest graph from my server.. I did not archive a picture of it when it was broken. Instead of text, each character was represented by a block.)
I had not ...

**0**

votes

**4**answers

8k views

### Set automatic axis limits for bar chart without defaulting to zero

I am building a bar chart in Excel with data values ranging from, e.g., 10 to 20. I want the x-axis limits to be automatic, but although the right limit (near 20) works correctly, the left limit ...

**6**

votes

**6**answers

25k views

### When embedding an Excel chart on a PowerPoint slide, why does the text look awful?

I have a recurring problem with Excel 2003/PowerPoint 2003, where I have a nice-looking chart in Excel and try to embed it on a PowerPoint slide. Quite often, the text in the chart (labels, axis ...

**5**

votes

**7**answers

49k views

### Map one column to x axis second to y axis in excel chart

I'm getting my ass kicked trying to plot simple data into a simple chart in excel (2010 beta).
My data is a very simple one:
Value Year
----- ----
1 1900
5 1902
3 1912
...

**3**

votes

**3**answers

4k views

### Graphical GUI for Graphviz on Mac?

I installed the Graphviz GUI from pixelglow.com, but it appears to only be a viewer for .dot Graphviz files. I am looking for a graphical editor, where I can create diagrams by pointing and ...