Ask Your Question

How to build a line chart with non continuous values?

asked 2016-05-04 20:33:17 +0100

alikim gravatar image

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,

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2016-05-05 03:01:09 +0100

genterminl gravatar image

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.

edit flag offensive delete link more

answered 2016-05-05 10:48:30 +0100

alikim gravatar image

That worked, thank you!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-05-04 20:33:17 +0100

Seen: 246 times

Last updated: May 05 '16