开发者

Range of values in Excel

开发者 https://www.devze.com 2023-04-03 13:50 出处:网络
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 t

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

精彩评论

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