Forum Discussion
Chart Disappears When Copying Sheet in Excel 2016
Colleagues,
In Excel 2016 I created a "master" chart with data that I need to replicate on several tabs also in Excel 2016.
I anticipated the Copy Sheet command would do exactly that -- but the chart does not appear on the copy of the sheet. Even if I select the chart before copying the sheet, it does not appear on the new sheet.
Is there a simple solution that will bring in the chart and point it to the data section on the sheet?
Thank you in advance,
Eric
1 Reply
Hello,
I cannot reproduce this. In my test, the chart is on copied sheets. What version and build of Excel are you using? File > Account shows the Office version underneath the Office logo and the section "About Excel" has the version and the build.
Can you post a sample file that shows the behaviour?