View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
J Shrimps, Jr.
 
Posts: n/a
Default Simultaneously updating Charts in Multiple sheets

Have a spreadsheet with 12 tabs.
Each tab has 12 line charts based on a specific group.
Each line in the chart represents one year (2000 -
2003) Data points are the months. We've
collected 60 months of data since 2000,
about 48 since 2001, 36 since 2002, 24 since
2003, etc.
Data is in columns as below.

Group 1
Month 2000 2001 2002 2003
0 99 % 39% 88% 90%
1 89 % 49% 77% 65 %
2 39% 88% 90% 92%
3 65 % 39% 88% 90%
4
5
6
etc.
There are 12 groups like that for each tab.
Each group has it's own chart directly below it.
Group one starts in columns A -E, skip a column,
Group two starts in columns G-J, etc.

I needed to add 2004 data, so I simply clicked
on each tab holding down the control key,
and inserted one column for each group.
I pasted 2004 data from my source file
into the new column for each group.

That was the easy part.
Is it possible to update all the charts within
a tab by selecting all of them and adding the new
(2004) column of data?
I really don't want to select each chart and
add the 2004 column to it. That would get
very old.