x-axis on chart "not to scale"

[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?

 

[David Biddulph]

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?

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

 

[rishi]

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

OK. That worked. I was using some other kind of chart...