Uneven spacing between x-values

  • Thread starter Thread starter Gary Thomson
  • Start date Start date
G

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.
 
Hi Gary,

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

Cheers
Andy
 
Back
Top