Am I trying to put too much data into a chart - what are alternatives?

This explains how to add/remove chart elements. You should be able to follow those instructions to add the horizontal/category axis to the chart: http://www.dummies.com/software/micr...in-excel-2016/

I'm not exactly sure what you hope to see from this data. Here's what I did, and what it showed me:

1) Add horizontal axis as noted above.
2) I hate 3D charts. You say that you are looking for "trends", so I thought that a basic 2D line chart might show something, so I changed the chart type to "line with markers".
3) It's still a busy chart. A few things that I could immediately see
3a) Early morning hours (2AM to 6AM) seem really quiet.
3b) Daytime and evening hours seem roughly constant (about 2200 lbs). I could perhaps talk myself into seeing that evening is slightly higher than afternoon, but I doubt it would hold up to statistical analysis.
3c) The one data point at 10AM Mon seems unusually high. Do I know anything about this data point that would let me decide that it is an outlier?
3d) The chart is busy, but I could not readily see any differences from one day to another. Friday ends earlier than the others, but I cannot tell if that is just for this week, or if that is a pattern over several weeks, and Saturday and Sunday seem to fit in with all the other days of the week, so I am inclined to ignore the early end on Friday.

That's what I see. What kind of trends or analysis do you expect to get from this particular data set?

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.

Yes it's possible. Though I wouldn't recommend doing it on same pivottable that you are basing chart on.
Unless you are aggregating data at daily level and not at hourly level.

I'd do it in separate pivot. Now with this, you can also show different aggregation (for an example, sum of Weighed out).

See attached, where I linked 2nd pivot, which has dates as column header, via slicer.

2nd pivot also is organized in Oldest to Newest.
Original is in reverse order since chart plots first item at bottom (Or you can set chart option to show category in reverse order).

You can also group dates into week group, monthly, quarterly as needed.