UNclustered column graphics

Copper Contributor

Hi - the graphic visual I wish to display is eluding me...

I have posted this req. on the Excel (general) site and have had no reply...
Office 365 (Excel) is of little use to me if the problem remains unsloved.

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.

0 Replies