Data Points

[CraigM]

How if possible can i get the data points in my chart to sit on the line
itself. i.e.

i have the numbers running along the bottom.

10 15 20 25 30 35 40

but the data states something should be on the 20 line, however the data
point shows in the middle of 20 and 25 so the person lookin a tthe graph
thinks the value is 22.5.

how can i stop this.

Thanks

Craig

 

[Jerry W. Lewis]

Change the chart type from "Line" to "XY (Scatter)".

The "Line" chart is very misleadingly named. It has nothing to do with
whether you want a connecting line or not. A "Line" chart assumes that
the x-axis is non-numeric category labels.

Jerry

 

[CraigM]

Hi,

That looks nothing like what is supposed to when i changed that.

Regards

Craig

 

[Jon Peltier]

Jerry's suggestion didn't help? What is wrong with the chart now?

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