Forum Discussion
Not able to copy and paste two of six pie charts from Excel worksheet
NB: Three-D pie charts are not a very good way of displaying your data or conveying your message. It is recommended to use a flat (2D) pie instead, or a bar chart.
- kkb_IHCOct 23, 2019Brass Contributor
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!!
- JKPieterseOct 23, 2019Silver ContributorPerhaps 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_IHCOct 23, 2019Brass Contributor
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.
- kkb_IHCOct 23, 2019Brass Contributor
Thank you for taking time to see if you have the same issue.
I will convert all pie charts to 2-D on your recommendation and just redo those charts. I've actually never used them before - usually use run charts. But need to be able to show parts of 100%.
kb