See
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html
If your data are on the same worksheet, example 4 should apply.
If your data are on different worksheets, use the INDIRECT function to
change the sheet name.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article , =?Utf-
8?B?SiBNYW5uaW5n?= <J
says...
Excel 2003: I have data for a number of branch offices that is set up in the
same format on a spreadsheet. I want to use the same chart to successively
display each branch's data and change the title to identify the branch.