Heat map may help as initial step.
Though not suitable when date range becomes much larger than current one.
0.JPG
Same as MrShorty, I hate 3d charts, it really adds nothing to insight and is just a visual fluff. There's more detriment than benefit to using 3d chart in my opinion.
Typically I'd use PowerPivot to summarize and analyze data (especially where time intelligence is involved).
Here's quick way to slice through data using various time frame using regular pivottable.
By week and Day of week as an example. Currently showing avg. weighed out.
You could have multiple pivottable/chart linked via slicer to show info in multiple charts, without overclouding single chart.
Max value for x-axis (value axis) is set to 4000.00 to keep consistent scale of bars across different slice.
NOTE: Probably should set to 5500 or whatever will be slightly larger than max value.
Bookmarks