开发者

Range of values in Excel

first thank you for your help. I am creating a simple chart in Excel with x and y 开发者_如何转开发axis. The thing is that I would like to define a range of values in order to not put all of them in the cells. Something like this:

   x          y
1-128         2
128-1234234 555

Is this possible?


Yes, it is possible. Make a chart of the end points of the ranges.

x       y
1       2
128     2
128     555
1234234 555

Then select the whole thing and insert a scatterplot with rigidly joined points. That will do it.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜