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 have tried CTRL-C, using the ribbon to copy as a picture, and using the ribbon to copy as a bitmap. Neither of them will go on my clipboard. I also tried a co-worker's PC and could not do it either.
Please help. I need to add these to a presentation for my boss!!
UPDATE: I have narrowed the issue down to the act of adding "values from cells" to the data labels on these two charts. I can copy them prior to adding "values from cells" and after adding them, the chart will not go on the clipboard.
20 Replies
UPDATE:
If I remove "values from cells" I am able to copy the chart. So, I will do that for now and later do some searching online to see why that causes the issue with this chart but not the others.
Agree with the previous author that, although Excel allows you to create such pie-charts it may be better to redesign them. But, you have them now and they work for you. Your only problem is that you can't copy and past them. I'm on a Mac and in my Excel version I can right-click on the chart and select "save as picture". Saved both graphs and pasted them into a Word doc. Attaching the document in case you still need the pictures for you presentation.
Thank you! I checked and in Windows, I do not have that option. Unfortunately, I attached a very generic example of my workbook.
I will convert all pie charts to 2-D on both of your recommendations.
Thank you for taking the time to generate the pictures.
kb
- I can reproduce your issue. I'm afraid you have little options other than recreating those two charts.
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.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!!
- 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.
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
