How to build a line chart with non continuous values?

[alikim]

I was able to plot the first column (as X, categories range) against the second column (as Y, values range).

X :
11
31
52
262
331

Y :
5
8
10
22
24

But what I want is X axis to run from 0 to 500 continuously with a certain grid like 0,100,200,300,400,500 and my first column x values to sit where they should on that line, instead of them being equidistantly placed on X axis.

Is it possible to do ?

Thank you,

[genterminl]

I think you want an X-Y chart (with points and lines), not a line chart. Your data range is A1:B5 assuming the X values flow down column A and the Y values flow down column B. Then you can manually set the X axis to the range of 0 to 500 with a major interval of 100.

[alikim]

That worked, thank you!