I am wanting to chart a range of data (scrap tracking) that utilizes the data validation list tool. i am having the user select the department(1,2,3) which the scrap occurred in from a drop down list, then enter the weight under which reason the scrap is attributed to (w,h,t). I have attached a copy of the test worksheet i am trying to do this with. I want the chart to recognize only the three departments not each entry (row) and have only one series per department. The totals should sum. Please advise on how i can accomplish this.
Thank you
Charting test.xlsx
Bookmarks