Forum Discussion
Not able to copy and paste two of six pie charts from Excel worksheet
This is interesting - thank you. I wonder if my data sheet is corrupted? I'll have to analyze each of the cells in the original sheet that appear on this particular graph. The version I attached doesn't have any formulas like my original, I did a copy/paste special/values in order to delete the sheets with PHI. I think I posted that I have tied this copy issue to the "values from cells" action for the data label. Before I do that, I can copy it fine. After I do that, I can no longer copy. FYI: I have another pie chart in this workbook that also has an issue with "values from cells," but it doesn't have to do with copying. When I include "values from cells" on the data labels, they just don't show up.
I was unable to copy the two bottom charts, either manually or using various VBA approaches. Neither Copy, Copy as Picture, nor Cut would work. I could make a copy by dragging the chart with the control key depressed, or by typing Ctrl+D (duplicate), but this restricts the copies to the active sheet.
It is not possible to copy the newer chart types (e.g. Waterfall) in VBA, but a workaround is to make a duplicate and cut it:
ActiveChart.Parent.Duplicate.Cut
Sadly, this does not work in this case (it works with the charts which can be copied).