Changing Chart Tab Reference

S

Scott

If I have two tabs in my Excel workbook, one which contains some financial
information for a company and several graphs and the other which which
contains the data the goes into the graphs. If I want to copy these two tabs
several times so that I can have the financial information and graphs for
several different companies in my workbook, is there an easy way to update
the tab that the graphs reference without manually changing the reference in
source data on each individual graph?

Thanks for the help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top