numbers on x axis

[Guest]

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.

 

[Jon Peltier]

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

 

[Bernard Liengme]

Double click x-axis of chart
On the Scale tab, set Major Unit to 5
best wishes