| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
loop to change source data in Excel Charts
Have mulitple charts. Source Data is :
='[different file]!sheet name'!range. The sheet from the different file has now been copied into the file where charts are. Is there an easy way to remove the different file name from all the Source Data references (for Name, XValues and Values) such that reference becomes simply: ='sheet name'!range |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying charts with automatic change of data source | Charts and Charting in Excel | |||
| Cannot change data source for copied charts | Charts and Charting in Excel | |||
| change source data in multiple charts | Charts and Charting in Excel | |||
| How to keep source data for the Excel Charts constant ... Please H | Charts and Charting in Excel | |||
| How do I create charts that change source data automatically? | Charts and Charting in Excel | |||
Threaded Mode
