| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I change the source worksheet for 100 charts automatically.
I have a worksheet with 100 charts that source a set of five worksheets,
financial forecast A. I create several forecasts (sets of 5 worksheets) and copy over worksheet with 100 charts, but the charts reference financial forecast A when I want them to source from financial forecast B. To change the chart source to financial forecast B, I now have to open each chart and change the source from A to B. Is there a way to do this automatically, similar to the edit, find, replace function for data in cells? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can charts automatically change by entering new range of dates | Charts and Charting in Excel | |||
| VBA to automatically change source data for existing chart | Charts and Charting in Excel | |||
| VBA to automatically change source data for existing chart | Charts and Charting in Excel | |||
| How do I create charts that change source data automatically? | Charts and Charting in Excel | |||
| change source worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
