| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart source data when copying from one workbook to another
I have a worksheet that contains one chart and and the chart's source data in
rows and columns in that sheet. If I select the worksheet and then move it to another workbook, the copied chart's source data still references the worksheet in the original workbook. For example, in Book1!Sheet1, the chart source data is 'Sheet1'!$A$1:$B$6. When I copy the sheet to Book1, the chart source data is '[Book1]Sheet1'!$A!1:$B!6. Is there a way to have the source data in the copy reference the new workbook or do I need to programmatically adjust the source data after copying the sheet? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying charts with automatic change of data source | Charts and Charting in Excel | |||
| Copying Charts While Changing Source Data | Charts and Charting in Excel | |||
| How to auto-increment data source cell references when copying cha | Charts and Charting in Excel | |||
| Copying data as static as source data changes | Excel Worksheet Functions | |||
| Returned: Copying a formula horizontally, the source data is verti | Excel Discussion (Misc queries) | |||
Threaded Mode
