x axis scale problem

[rishi]

I've got two columns of data - one is "years" and goes 1, 2, 4, 5, 10,
50, 100, 250, 500, 1000.

When I graph it, I get an "equidistant" x-axis. That is, 1 is as far
from 2 ans 500 is from 1000. I would like it to be "to scale". That
is, 500 to 1000 takes up half the axis, and 1,2,4, 5, 10, 50 take up
only 5% of the axis.

How do I do that?

 

[Jon Peltier]

Use an XY Scatter chart.

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