Chart with X Values

[faceman28208]

I have a number of data pairs that I would like to graph in a line
chart. They are in (X,Y) format. I would like to get a chart (e.g.
line chart) of these values such that each Y value is plotted at the X
value.

Every combination I have tried plots the pairs evenly spaced in the
order they occur in the data sheet with the X values apparently only
serving as labels.

In other works, if I have

1 1
3 3
2 2
5 5

I would like to get a chart showing a straight line.

How would I go about doing this?

 

[Andy Pope]

Hi,

The Line chart uses a Categorical axis, except when doing Time series.
Instead use the XY-Scatter chart type. This plots both points as
numerical values.

Cheers
Andy

 

[Bruce Sinclair]

Hi,

The Line chart uses a Categorical axis, except when doing Time series.
Instead use the XY-Scatter chart type. This plots both points as
numerical values.

... and IIRC, scatterplot is the *only* chart type that allows variable x
axis differences ! This is (or certainly was) a serious trap for young
players.