Forum Discussion

Eric Fisher's avatar
Eric Fisher
Copper Contributor
May 17, 2018

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?