I have a set of data of all the stops in the plant here. The data is arranged in columns as followed:
- Column A Fabrication number
- Column B Start Date
- Column C End date
- Column N observation (this is the filter for the graph you are seeing)
- Column X Team (These are the rows in the axis on the graph (team A, B and C)
- Column AM Week number (by using WEEKNUM() on the start date)
All the other columns also contain data, but this data is not used to make the graph. The pivot chart uses column N as filter, column X as column label and column AM as row label.
I'm working with pivot charts in excel and powerpoint (the ones in powerpoint are linked to the ones in excel).
I would like to add the sum of errors after week 52 in the graph, but I can't find an easy way to do this.
I already googled this, but all the solutions seem to be quite elaborate. On google they mostly suggest to modify your data such that you can become a "grand total" and add this to the pivot table or to copy the data in a normal stacked chart, but this will remove the link between the data and the powerpoint presentation.
My question is: Is there an easy built-in solution for this?