I have a question on Pivot Tables and Charts. I want to know how to add new data to a Pivot Table when you have already completed a Pivot Table chart. For instance, on the Pivot Table I used names of states and numbers of female to male doctor ratios within that state. When I completed the clustered column chart, I later saw that I missed a state and its information. When I tried to put the information in I was not able to. How do I add the information without having to start all over?
Well, we can always add data to the source table and then refresh manually the pivot table or automacally, when opening the workbook. But..
Is there a way to update data in the pivot table really dynamically, that is, right after adding or changing data in the original source table (without having to manually refresh the pivot table, or automacally, opening again the workbook)?