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

John Bebb

Copper Contributor

May 04, 2018

At the suggestion of "Dadof 5" - of the Microsoft Community (the sole person who has had the consideration to reply)...

I attach "Raw timing#1a.xls"

Sheet #1 is raw data (greyed) & initial processing...
Sheet #2 uses a small sample of Sht#1 data to demonstrate the graphicical issues.

Thank you.

Raw timing#1a.xlsx248 KB

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.