Forum Discussion

Copper Contributor

Apr 27, 2018

Clustered data to UNclustered column charts?

Hi - the graphic visual I wish to display is eluding me... Data cols. are clustered time stamps & appropriate frequency counts; - I can display as req. with UNclustered timestamps – (as a 2d-Li...

Charts & Visualizing Data

Requests

SergeiBaklan

Diamond Contributor

May 04, 2018

Hi John,

Yes, that's since you use time intervals smaller than days. Here only scatter chart works. See, for example

https://social.msdn.microsoft.com/Forums/office/en-US/db036e1d-247e-412a-b733-17752ab016dc/how-can-i-build-a-graph-with-a-time-axis-based-on-minutesseconds-milli-seconds-excel2010?forum=exceldev

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other-mso_2016/excel-graph-create-a-15-minute-interval-in-axis/63a0a3cf-1e8d-4a7c-831a-f4688a678862

John Bebb

Copper Contributor

May 04, 2018

Sergei; -
thank you for your response.
That is most disappointing.... and an appaling omission on behalf of the Excel programmers...
There are innumerable applications where sub-day unclustered columnar data is usefully applied - here is one common example: - https://www.bbc.co.uk/weather/co14

So please - does anyone have any suggestions to circumnavigate these GLARING INADEQUACIES of Excel?

Thank you.