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

learn more… | top users | synonyms (3)

3
votes
3answers
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
4answers
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
2answers
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
2answers
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
3answers
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
1answer
406 views

Free software to plot cartograms

Is there any free software to plot cartograms?
1
vote
1answer
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
1answer
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
2answers
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
4answers
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
1answer
7k 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
2answers
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
1answer
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
1answer
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
2answers
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
7answers
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
5answers
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
4answers
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
4answers
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
2answers
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
4answers
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
1answer
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
4answers
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
6answers
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
7answers
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
3answers
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
1answer
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
2answers
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
1answer
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
1answer
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
3answers
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
1answer
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
1answer
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
4answers
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
1answer
1k views

Box and whisker graph in Excel

Is there a way to draw a Box and Whisker graph in Excel?
1
vote
2answers
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
3answers
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
3answers
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
7answers
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
2answers
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
4answers
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
4answers
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
3answers
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
5answers
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
4answers
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
2answers
2k views

Graphing by time in Excel

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