ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   grouping cells within a column for a chart (https://www.excelbanter.com/excel-programming/453043-grouping-cells-within-column-chart.html)

[email protected] January 9th 17 11:03 PM

grouping cells within a column for a chart
 
I have many cells in one column that I would like to chart. I would like to group them to make the chart more readable. 49-55 is one group 78-84 is another chart, etc.... How would I do this?

49.667446
49.857418
49.875416
49.899414
49.969402
49.975403
50.108379
50.12838
50.144375
50.149376
50.284355
50.429333
50.84827
50.867268
50.869267
50.924255
51.049236
51.848118
51.941105
52.012093
54.999638
55.430573
58.045174
......
78.668037
78.73703
78.799019
79.134972
79.43792
79.609894
79.719879
79.822868
80.32579
80.337784
82.914391
84
85.536995
85.700974
86.865791
89.67337


All times are GMT +1. The time now is 12:05 AM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
ExcelBanter.com