If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copy a group of Chart tabs
I have a group of chart tabs, 4 for each month, each tab contains multiple
charts (between 2 and 12 per tab). The series data in the charts comes from one worksheet tab (in this case Sep09) At the start of a new month I want to copy the group of 5 tabs and rename them (eg Oct09), however when I do this most of the charts still refer back to the Sep09 tab. I then have to go through all of the charts and manually change the sheet reference in the series data ranges. Is there a way to avoid all of this manual intervention? I am using Excel 2007. I am using Excel 2007. |
Thread Tools | |
Display Modes | |
|
|