If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copying charts to other worksheets
Is there a way to copy a chart to another worksheet within a workbook, and
have it change the worksheet referenced in the source data? I am asking this because I have 7 sheets setup exactly the same way, and need graphs for each, but would like to avoid having to reassign the ranges for each sheet. |
#2
|
|||
|
|||
Copying charts to other worksheets
Dave -
This is the easiest way: make copies of your sheet with the chart (the chart on the copied sheet will refer to the data on the copied sheet), then copy the new data, and use Paste Special from the Edit menu, and use the Values option. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Dave R. wrote: Is there a way to copy a chart to another worksheet within a workbook, and have it change the worksheet referenced in the source data? I am asking this because I have 7 sheets setup exactly the same way, and need graphs for each, but would like to avoid having to reassign the ranges for each sheet. |
#3
|
|||
|
|||
Copying charts to other worksheets
Thanks Jon, that worked and saved me some time! I used regular paste and it
worked as far as I can see. Dave "Jon Peltier" wrote in message ... Dave - This is the easiest way: make copies of your sheet with the chart (the chart on the copied sheet will refer to the data on the copied sheet), then copy the new data, and use Paste Special from the Edit menu, and use the Values option. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Dave R. wrote: Is there a way to copy a chart to another worksheet within a workbook, and have it change the worksheet referenced in the source data? I am asking this because I have 7 sheets setup exactly the same way, and need graphs for each, but would like to avoid having to reassign the ranges for each sheet. |
Thread Tools | |
Display Modes | |
|
|