numbers on x axis
 

Hello all,

I'm kinda new to this, but I'm learning, so please bear with me. My
question is this.
I am trying to set up a xy scatter chart to plot points of a test that I
take for my job. Only thing is, I would like to change the x axis to read 5,
10, 15, 20, 25, 30, 40, 50, 60. This is the interval at which I take the
reading of my test, 5 minutes, 10 minutes, etc. I put the readings in column
A1 thru A9. The reading are correct, but the numbers in the x axis read 0,
2, 4, 6, 8, 10. I would like to put A1 on the 5 minute mark, so on and so
forth.

I am running Microsoft Excel 2003 version.

numbers on x axis
 

1. Make sure it's an XY chart, not a Line chart.
2. Make sure the values in column A are numeric, not numbers stored as text.
Any text will mess up the X axis.
3. Go to Chart menu Source Data Series tab. Select the series in the
list, and ensure that A1:A9 is properly entered in the X Values box.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"p-nut" wrote in message
...
Hello all,

I'm kinda new to this, but I'm learning, so please bear with me. My
question is this.
I am trying to set up a xy scatter chart to plot points of a test that I
take for my job. Only thing is, I would like to change the x axis to read
5,
10, 15, 20, 25, 30, 40, 50, 60. This is the interval at which I take the
reading of my test, 5 minutes, 10 minutes, etc. I put the readings in
column
A1 thru A9. The reading are correct, but the numbers in the x axis read
0,
2, 4, 6, 8, 10. I would like to put A1 on the 5 minute mark, so on and so
forth.

I am running Microsoft Excel 2003 version.

numbers on x axis
 

Double click x-axis of chart
On the Scale tab, set Major Unit to 5
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"p-nut" wrote in message
...
Hello all,

I'm kinda new to this, but I'm learning, so please bear with me. My
question is this.
I am trying to set up a xy scatter chart to plot points of a test that I
take for my job. Only thing is, I would like to change the x axis to read
5,
10, 15, 20, 25, 30, 40, 50, 60. This is the interval at which I take the
reading of my test, 5 minutes, 10 minutes, etc. I put the readings in
column
A1 thru A9. The reading are correct, but the numbers in the x axis read
0,
2, 4, 6, 8, 10. I would like to put A1 on the 5 minute mark, so on and so
forth.

I am running Microsoft Excel 2003 version.