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

**0**

votes

**1**answer

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

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

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

**1**answer

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

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

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

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

**2**answers

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

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

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

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

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

**5**answers

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

**5**answers

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

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