x-axis on chart "not to scale"

R

rishi

I've got two columns of data. One column is "Year" and it has entries
1,2,4,5,10,50,100,250,500,1000. That's going to be the x-axis.

Unfortunately, when I graph it, excel puts the years EQUIDISTANT. 1 is
just as far from 2 as 250 is from 500.

I wanted a chart with an x-axis to scale. This means that 1,2,4,5,10
are all crammed in on the left, and 500 is way out to the right.

How can I get that to scale?
 
D

David Biddulph

rishi said:
I've got two columns of data. One column is "Year" and it has entries
1,2,4,5,10,50,100,250,500,1000. That's going to be the x-axis.

Unfortunately, when I graph it, excel puts the years EQUIDISTANT. 1 is
just as far from 2 as 250 is from 500.

I wanted a chart with an x-axis to scale. This means that 1,2,4,5,10
are all crammed in on the left, and 500 is way out to the right.

How can I get that to scale?
Click to expand...

What type of chart have you used? Try xy (scatter).
 
Top