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

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 wrote:

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

Hi,

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

Regards

Craig

"Jerry W. Lewis" wrote:

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 wrote:

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'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/
_______


"CraigM" wrote in message
...
Hi,

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

Regards

Craig

"Jerry W. Lewis" wrote:

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 wrote:

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