Chart Help Please

[ll]

Excel 2002

I have a simple chart: two columns (A and B) and 29 rows.
Column A is years, from 1980 to 2008.
Column B is some value between 0 and 9.

Example:
1980 0
1981 1
....
2008 4


I created a chart.
It plots the points fine, they are where they should be.
The Y axis is fine, numbers from 0-9, label is OK.

But I cannot get it the X axis to use the years (1980 - 2008).
Instead it is labeled 1-29, which are the Excel _row numbers_.

I want the x axis values to be the _years_ from Column A.

How do I do this?
Thanks.

 

[smartin]

Excel 2002

I have a simple chart: two columns (A and B) and 29 rows.
Column A is years, from 1980 to 2008.
Column B is some value between 0 and 9.

Example:
1980 0
1981 1
...
2008 4


I created a chart.
It plots the points fine, they are where they should be.
The Y axis is fine, numbers from 0-9, label is OK.

But I cannot get it the X axis to use the years (1980 - 2008).
Instead it is labeled 1-29, which are the Excel _row numbers_.

I want the x axis values to be the _years_ from Column A.

How do I do this?
Thanks.

Hi,

Actually, the x-axis is automatically assigning category numbers (not
using row numbers) as labels, probably because you have not specified
where the x-axis labels should come from.

It's easy enough to resolve though.

Right click in you chart and pick Source Data...

Click the Series tab if it's not already chosen.

Your series is probably highlighted already. Is the "Category (X) axis
labels" control empty? Click the control handle, then on your chart use
the mouse to select A1:A29. Finish the job by clicking the control
handle in the little pop-up window.

Ok your way back out.

 

[ll]

Is the "Category (X) axis labels" control empty? Click the
control handle, then on your chart use the mouse to select
A1:A29.

That was it. Thank you very much.