Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Copy a group of Chart tabs
Do not copy and paste from cells/chart
Rather copy the entire worksheet by right clacking its tab and using Copy/Move option in the popup menu best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Mr Christopher" <Mr wrote in message ... 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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Copy a group of Chart tabs
I am copying a group of tabs, by holding the Ctrl Key and sellecting multiple
tabs. I may also have found a solution; I make a copy of the work book, overwrite the data in Sep09 then rename the tabs Oct09 etc then move (not copy) to the original workbook. "Bernard Liengme" wrote: Do not copy and paste from cells/chart Rather copy the entire worksheet by right clacking its tab and using Copy/Move option in the popup menu best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Mr Christopher" <Mr wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tabs on bottom of sheet are all white in Group Mode. | New Users to Excel | |||
Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
I wish to group my worksheets under group tabs | Excel Worksheet Functions | |||
Create tabs named after a group of cells? | Excel Discussion (Misc queries) | |||
How can i copy a group of cells in a row to a column? | Excel Discussion (Misc queries) |