Batch changing data range for multiple charts?

takutaku · #1 09-08-2008, 01:29 AM

Hi,

I have a worksheet which consists of multiple columns, for example:

18 to 21 yr old | 21 to 25 yr old | 25 to 30 yr old | Total

Under each of these columns I have inserted several rows which contain data from a survey.

On another sheet, I've created several charts using data from the 18 to 21 yr old column.

My question is - is there a fast way to change the data range of the charts from the 18 to 21 yr old column to the 21 to 25 yr old column without having to painstakingly adjust each chart manually?

I would like to end up with a series of sheets which contain identical charts for each age range.

I'm using Excel 2007.

Thanks :-)

**Andy Pope** · #2 09-08-2008, 05:08 AM

You could create some code to change the data ranges.
If you only have 4 charts I would do it manually.

takutaku · #3 09-08-2008, 06:05 AM

For those who are interested: http://peltiertech.com/Excel/Charts/ChgSrsFmla.html

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Charting a Changing Data Range	SkyBluesFan	Excel Charting	3	07-15-2008 09:17 AM
Changing chart source data in VBA	drdavidge	Excel Programming	5	12-01-2007 01:37 AM
Changing chart source data in VBA	drdavidge	Excel Charting	0	11-27-2007 05:31 PM
Auto Data Range AND Filter Criteria	RichardBerry	Excel Charting	3	09-17-2007 08:44 AM
Changing VBA code to return data range, appending to prior data	camcrazy08	Excel Programming	3	08-21-2007 11:53 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)