LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print all charts in a workbook (multiple worksheets) aewsaws Charts and Charting in Excel 4 May 12th 23 03:45 AM
Insert same picture in multiple sheets and only change once Mike Excel Discussion (Misc queries) 3 February 7th 06 03:05 PM
Sorting multiple worksheets simultaneously Bannor Excel Discussion (Misc queries) 0 January 10th 06 12:33 PM
How do I set print areas for multiple sheets simultaneously? Twirly Excel Discussion (Misc queries) 3 January 9th 06 12:16 PM
Macro for multiple charts JS Excel Worksheet Functions 1 November 19th 04 03:44 AM


All times are GMT +1. The time now is 08:36 AM.

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

About Us

"It's about Microsoft Excel"