Mikerose722
New Member
- Joined
- Jan 25, 2006
- Messages
- 4
I have a number of pivot charts in Excel that need to be updated monthly with new data that is added to the data source. The data source and all the Pivot Charts are in the same workbook but on a different tab. I thought I would be able to Refresh All to update the charts but that didn't work. I decided to right click on the chart to edit the data with the Select Data option. However, the Chart Data Range is grayed out. How can I get the chart to update with refreshing the data or at least be able to select the new data range?