PapaGeek
New member
I have an Excel spreadsheet where Sheet1 contains a series of numbers and a line chart that graphs those numbers. I want to make a copy of the page so I can work on the numbers without changing the original data.
Steps:
The new sheet looks identical, but the Sheet2 line chart still points to all of the data from Sheet1.
Is there a way to make a duplicate copy of a page and have the newly created chart point to the data on the newly created page, not point to the original page?
Steps:
- Create a new Sheet2
- Click on Sheet1 tab
- Control A to select the entire sheet
- Control C to copy data and chart to clip board
- Click on Sheet2 tab
- Control V to paste everything onto Sheet2
The new sheet looks identical, but the Sheet2 line chart still points to all of the data from Sheet1.
Is there a way to make a duplicate copy of a page and have the newly created chart point to the data on the newly created page, not point to the original page?