I have a lot of graphs connected to specific Pivot charts. The Pivot Charts are refreshing when I enter in new data but the graphs connected to them will not refresh when I hit the refresh all button. I go to the graph and click the "Analyze" tab and everything is grayed out and will not let me select any options. Is there anyway of fixing this? I have almost 50 graphs and would hate to have to remake them all.
Thanks
Thanks