Forum Discussion

Brass Contributor

Oct 22, 2019

Not able to copy and paste two of six pie charts from Excel worksheet

If you look at the pie charts tab in the attached file, I have a note and arrows pointing to the bottom two pie charts. I am absolutely not able to copy either of these and then paste somewhere. I ha...

ED and IP Analysis Copy NO PHI.xlsx354 KB

copy

excel

kkb_IHC

Brass Contributor

Oct 23, 2019

JKPieterse

You will not believe it - I converted all the pie charts to 2-D, copied one of the ones that will copy, changed the data to be the data from the first chart that would not copy, AND - that one will not copy either!!

JKPieterse

Silver Contributor

Oct 23, 2019

Perhaps this is caused by the fact that the source data is spread out over non-adjacent cells? I don't really know. I tried to create an intermediate table with source data for the bottom-left chart and it did not help.

kkb_IHC
Brass Contributor
Oct 23, 2019
JKPieterse
I don't think it is the issue. All the pie charts have non-contiguous cells. I even completely recreated the chart on a new tab and it will not copy either. I started monitoring my clipboard, and the issue is that it won't go on the clipboard. I have a pie chart that is more complicated (more slices) and it WILL copy. Of course, I have an issue with that one too - I have tried to add "value from cells" to the data labels and they just won't show up.

I should state that I am using Office 365 and from doing some searching, it may have some overall clipboard issues.
- JKPieterse
  Silver Contributor
  Oct 23, 2019
  The odd thing is, if I uncheck "Locked" of the two charts, I can copy and paste them. But the other charts are all locked and can be pasted.
  - kkb_IHC
    Brass Contributor
    Oct 23, 2019
    JKPieterse
    Where are you unchecking that? I can only get to it if I select cells, not a chart.