Uneven spacing between x-values

[Gary Thomson]

Hi,

Hi, I am trying to construct a line graph in Excel, with
the following data points:

(30.00,2.72); (38.62,3.44); (40.23,3.58); (41.89,3.72).

The line that intersects all these points should have the
same gradient.

However, when I input these values into the line graph in
Excel, it is showing differing gradients, due to the fact
that it is displaying the same "virtual distance" between
the x-coordinates of 30 and 38.62 as it is between 38.62
and 40.23.

WHy is it doing this?

Many Thanks,

Gary.

 

[Andy Pope]

Hi Gary,

Try changing thechart type to xy-scatter instead of the Line chart. Line
charts have category values on the xaxis.

Cheers
Andy

 

[Gary Thomson]

Andy,

Thanx, that works

Gary.

-----Original Message-----
Hi Gary,

Try changing thechart type to xy-scatter instead of the Line chart. Line
charts have category values on the xaxis.

Cheers
Andy



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
.