| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart references and worksheet copying -- HELP!
I have an Excel worksheet with a chart on it. If I make a new copy of the
sheet, the chart is copied as well, but it refers to data on the ORIGINAL sheet, not the copy. I could manually change the chart data range, but it there any way that this could be done at the time the worksheet is copied? What if I had several charts? This could get time consuming. I basically want to copy an entire worksheet, often with several charts, and have the charts on the new worksheet refer to data on the new worksheet. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy of a Worksheet Does Not Update Chart References | Excel Worksheet Functions | |||
| Chart data references not changing to new tab when worksheet is co | Charts and Charting in Excel | |||
| copying a worksheet tab with a chart, without losing chart formatt | Charts and Charting in Excel | |||
| Excel Chart-data references link another worksheet in same workboo | Excel Discussion (Misc queries) | |||
| How do I keep chart/data link when copying worksheet | Charts and Charting in Excel | |||
Linear Mode
