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.
|