Hi everyone,
I have a workbook, which I use for different departments that displays a number of different pie charts and I have found that a particular pie chart omits a specific label repeatedly. The pie chart displays the wedge within the chart itself, but does not display the label. At the moment I have data labels with percentages. All other labels display, of which there are 7. I found a solution that fixes the problem each time it arises and that is to select Chart Tools/Format/Series 1 data labels and then Format Selection. When I then select any data label, I click on "Clone Current Label" and the missing label appears with the correct percentage amount.
I was wondering if the problem is a common one, or if there is a more permanent solution.
I use the workbook for multiple uses and rather than have it present as a template (*.xltm), it is a macro-enabled spreadsheet (*.xlsm). Could this be related to the problem?
Many thanks in advance for your help.
Cheers,
Spero.
Bookmarks