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

**3**

votes

**3**answers

714 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

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

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

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

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

407 views

**1**

vote

**1**answer

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

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

494 views

### Best software to build charts (pies, bars)

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

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

606 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

**2**answers

20k views

### What is the best free Gantt project tool out there? [closed]

I've gone through some of the other posts on superuser and some other online resources to find the answer to this question, but I'm not satisfied with anything I've found. Basically, I just need a ...

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

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

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

394 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

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

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

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

**0**

votes

**1**answer

83 views

### Plot an area defined by a parameter range of

If I have something like this:
y = sin(x+z)
How can I plot the values of y, as a function of x and all the possible values of z in [-0.1, +0.1]?
That is, I want the area defined by those limits. ...

**1**

vote

**2**answers

1k views

### Interacting w/ Graphs Using VBA in Word 2007

I have a long MS Word 2007 document, in which I occasionally need to replace all of the embedded graphs.
The changes are simple enough and regular enough that I could probably write a VBA macro to ...

**0**

votes

**1**answer

907 views

### Product sales chart in Excel, from data in Access

I have a table in an Excel 2007 worksheet containing details of orders (note: I have manually changed the details to be fake on everything)
I want to count the number of products ordered for a ...

**2**

votes

**1**answer

3k views

### Excel Chart X Axis Values

I'm trying to create a line chart in Excel with the following values from my sheet:
(0,100)
(1,90)
(2,80)
(4,70)
(8,60)
(16,50)
The problem I can't work around is that I want the 0, 1, 2, 4, 8, 16 ...

**0**

votes

**3**answers

451 views

### How to create label on chart containing contents from a cell on another sheet?

Simple problem. I have a chart in Excel and some text data on a sheet. I want to create labels on the chart that reference text on another sheet. I want to be able to update the text and have the ...

**1**

vote

**1**answer

65 views

### How can I generate a dotplot of general files?

On a few occasions I've seen some papers that apply bioinformatics dotplots (aka recurrence plots) to general files, to demonstrate things like beat detection in music, or relationships between .dll ...

**0**

votes

**1**answer

4k views

### How can I set text wrapping on an Excel chart in Word 2007?

Title says it all realy. I'd like to apply square text wrapping to an Excel chart inserted into my document. The normal options don't seem to exist. Is there any way of doing this other than inserting ...

**4**

votes

**4**answers

528 views

### Good graph plotting app

Does anyone know of a free graph plotting app for windows (or online) that can plot something like this?
Xn+1= r sin (π * Xn)

**1**

vote

**1**answer

1k views

**1**

vote

**2**answers

2k views

### Distribution of values as a graph in excel

I have a set of 1-D data (0,0,0,1,2,1,1,5,6,1,1,100,1,etc) and I'd like to generate a graph from it that shows the number of values in a set of ranges. I.e
0 - 3
1-7 - 8
8-30 - 0
30+ - 1
The data ...

**3**

votes

**3**answers

30k views

### How to rename the values on Y Axis in Excel?

I'm trying to rename the values that are on my Y Axis on a chart in excel. Currently I have mapped various letters to number equivilants just to get it plotted, but would like now to have the letter ...

**1**

vote

**3**answers

69 views

### Statistical testing of step variables

I have three variables I'd like to analyze. Two of them are step values - one set ranges from 1-6 and the other ranges from 1-5. The third variable is not a step value but can have a relatively wide ...

**0**

votes

**7**answers

17k views

### Excel automatic axis scale completely inappropriate for data

How can I make Excel use the correct scale on its graph axis? For example, I have a graph which looks like the following:
The x-axis has the wrong scale - it should range from about $3000 to ...

**1**

vote

**2**answers

5k views

### How can I create a pie-chart with gnuplot?

I want to create a pie-chart. Is that possible with gnuplot and how to realize that?

**1**

vote

**4**answers

156 views

### Any good online chart generators? [closed]

I am looking for some free site that allows you to easily create a chart from provided data (in interactive mode, so I don't have to write any code) and export it to an image. Can anyone recommend ...

**4**

votes

**4**answers

1k views

### MSFT Excel pivot table links to external data

Question1: What is the best online forum to ask MSFT Excel questions of the following variety?
Question2: How can I link an excel pivot-table to a potentially changing source table without having to ...

**1**

vote

**3**answers

467 views

### Creating Flowcharts in the Office Suite

I need to create a couple of flowcharts and I am wondering which of the Microsft Office products are best suited to doing so (Word, Powerpoint, Excel?). Do any/all of these have flowchart creation ...

**1**

vote

**5**answers

593 views

### Unable to create charts for all values in an entire column in Excel 2003

My Excel data looks like this: (it's a lot bigger in fact)
code1 code2 01/08 02/08
X A 12 10
X B 8 15
Y A 52 0
Y B 5 5
Every day I ...

**3**

votes

**4**answers

58k views

### Excel chart: How to reverse the X axis of time series data

In Excel 2003, I have a time series from a financial report that goes something like this:
2007 2006 2005
Amount 300 200 100
I want to create a graph of the time series that looks ...

**5**

votes

**2**answers

2k views

### Graphing by time in Excel

I have a data set (~2000 rows) with the following form:
+---------------------+-----+-----+-----+-----+-----+
| Datetime | n1 | n2 | n3 | n4 | tot |
...