Forum Discussion
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-Line variant) but only as event "dots", not as individual vertical bars wrt time... all attempts to draw the bars (columns) from the event(s) dots result in clustering...
I cannot achieve an UNclustered column chart of the sourced data.
Further investigation implies a histogram is not (by definition) appropriate: -
The requirement is to create a column (i.e. vertical bar) chart in UNclustered form,
I believe the problem is that the data as sourced is clustered Date & Time format...
I would have thought that it should not be necessary to UNcluster the data, but that the chart graphics processing should be capable of determining that the data is in D & T...
I wish to graphically process the data into various separate DD, MM HH and mm bins
but to UNcluster the sourced data will make the sourced data visually unreadable!
any suggestions please?
Thank you, bebbspoke.
- John BebbCopper Contributor
PLEASE - Excel Tech - is no one prepared to answer???
- John BebbCopper Contributor
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.Hi John,
Yes, that's since you use time intervals smaller than days. Here only scatter chart works. See, for example