Data Points

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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/
_______
 
Back
Top