A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Copy a group of Chart tabs



 
 
Thread Tools Display Modes
  #1  
Old September 15th, 2009, 03:09 PM posted to microsoft.public.excel.charting
Mr Christopher
external usenet poster
 
Posts: 1
Default 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.
  #3  
Old September 16th, 2009, 03:57 PM posted to microsoft.public.excel.charting
Mr Christopher[_2_]
external usenet poster
 
Posts: 1
Default 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.






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:09 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.