Scaling the x-axis on a line chart

G

Guest

I am having trouble scaling the x-axis so that the intervals are equal. The
source data is not in equal intervals, it goes
0.0,0.2,0.4,0.45,0.5,0.6,0.7,0.8,0.9 (I think). What can I do to make the
interval on the graph 0.2? I'm using XP.
 
J

Jon Peltier

Don't make a line chart. Make an XY chart, using the markers and lines
option. Then you can double click the X axis and set any appropriate
tick spacing.

An XY chart treats X and Y as continuously varying numerical values. A
line chart treats Y that way, but treats X as non-numerical text labels.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top