Forum Discussion
Graph Not Updating with New Data
Thank you. The source range of the column chart is on the sheet itself, so when you copy the sheet, the source range is copied with it.
But the source range of the pie chart is on the hidden sheet 'Chart Data':
So when you copy the 'Current Month' sheet, the source range of the pie chart remains the same.
You can do the following:
- Unhide the 'Chart Data' sheet.
- Duplicate it.
- Adjust the formulas in B5 and B6.
- Change the source range of the pie chart on 'Current Month (2)' to refer to the copy of 'Chart Data'.
See the attached version. I left 'Chart Data' and its copy visible, so that you can see what I changed.
Hi HansVolgelaar,
I'm just using the template data as an example. When you change the data on the second tab, the pie graph doesn't update. The template is attached.
https://1drv.ms/x/s!ArivCaK97lsikEnt5nlPTJX42ae4
Thank you. The source range of the column chart is on the sheet itself, so when you copy the sheet, the source range is copied with it.
But the source range of the pie chart is on the hidden sheet 'Chart Data':
So when you copy the 'Current Month' sheet, the source range of the pie chart remains the same.
You can do the following:
- Unhide the 'Chart Data' sheet.
- Duplicate it.
- Adjust the formulas in B5 and B6.
- Change the source range of the pie chart on 'Current Month (2)' to refer to the copy of 'Chart Data'.
See the attached version. I left 'Chart Data' and its copy visible, so that you can see what I changed.
Thank you so much HansVogelaar.
Correct me if I'm wrong, but if I change the name of the 'Current Month' to Jan, Feb, Mar, etc, I will need to change the source to match the name.
Excel should do that automatically.