Quote:
Originally Posted by gebobs
I used a couple of pivot tables. The one on the Total tab gives the totals for each Item. The one on the By Item tab breaks it down by each. The chart can be filtered for each item either on the chart or on the pivot. If you don't want to bother with that, you'll have to create separate pivots and charts for each.
The file is in .xlsx format. Not sure what will happen if I save to .xls. Let me know if you can't open it.
|
Wow, that looks really nice!
I don't quite understand [the steps] how you got to the end result, so it will take me some time to grasp what you are talking about.
Thank you for your time! I'll write again once I have a better understanding of all the things I don't understand (particularly pivot tables).
