Forum Discussion
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...
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.
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.
- 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.
Where are you unchecking that? I can only get to it if I select cells, not a chart.
kkb_IHC Here: