Help on questions about graphs, charts and other graphical methods to show data.

learn more… | top users | synonyms (3)

0
votes
1answer
901 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
437 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
64 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
525 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
2answers
28k 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
16k 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 ...
0
votes
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
449 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
582 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
5answers
54k 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 | ...