Hello! It's me again with the same spreadsheet.
1. The order quantity tab isn't showing the correct numbers for February FP/RP. The quantities should be FP 15 & RP 132 but it shows 6 for RP only.
2. Also, right now I am inserting a text box on the actual chart and manually inputting the quantities. Is there a way to make this not a manual process? What happens is when I update the data I have to remember to go to the actual chart and update the quantities (I use the order quantity tab so that I don't have to filter & count it from the source data).
3. I would like to add the the PO delay reason (column F) as a secondary chart/pivot and wanted to get some recommendations on how I should display that data. I was thinking maybe just a pie chart? But not sure....thoughts?
Thanks in advance!