Is there a way to change the source data of multiple graphs without having to make the changes to each individual graph? Currently I have to change 7 Series values in 15 different graphs once a week. It's very tedious and I'm wondering if there is a way Excel can make this process more efficient.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Source Data changes to muliple graphs
- Thread starter hmckay77
- Start date
javajoe
Board Regular
- Joined
- Nov 7, 2005
- Messages
- 78
Aaaaahhhh yes.... I do the same each week and would be interested in any solutions. The only work around I've discovered is to insert a row in the second to last row of my data range. Doing this causes all graphs that point to the data to automatically include the incremental row, which eliminates the need to touch every graph.
Upvote
0
