Pivot table fields not updating
I am going to do a complete tear down of how did I do it. Cell naming is important because we will refer to these cells in our VBA Code not with their cell addresses but by their names.
If at all you are wondering why are the Serial numbers in the right column, Well.. The LEFT & SEARCH are used to extract the first word from our first Pivot Table.
That is, for one I use "Show values as" "% of total" and for the other I use "Normal".
It is done by defining names per column by typing the below code into the "refers to"-box under "define name" (assuming the information you want to include is in column Define names for all series and the axis labels you want included in your chart.