Want to use same Chart against changing data and variable titles?

[J Manning]

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.

 

[Tushar Mehta]

See
Dynamic Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/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