Adding worksheets to workbook - charts

[srburk]

I know how to add a new worksheet and copy a template from one sheet to a new. Each worksheet contains a chart.

When I copy one worksheet into a new worksheet, the copied chart links to the original sheet from which I am copying.

Is it possible to copy a worksheet (and it's chart) onto a new worksheet and have the attached chart look at the new worksheets data without referring back to the old?

Scott

 

[GlennUK]

Copy the worksheet by right-clicking the tab and doing Move or Copy, instead of copying the contents.

 

[srburk]

Copy the worksheet by right-clicking the tab and doing Move or Copy, instead of copying the contents.

Thanks! That works!

 

[GlennUK]

Great! Glad to be of help