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

Copper Contributor

May 03, 2018

PLEASE - Excel Tech - is no one prepared to answer???

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.

Resources