Hello,
I have been building pie charts as well as clustered column and bar charts and am wondering if there is a way to make the data labels automatically appear/disappear with changes in the data. Specifically, if the value is 0% in a pie chart, I don't want the data label to show, but as soon as it becomes >1% I want it to appear. Is there an easy way to do this versus constantly removing and re-adding the data labels?
I have been building pie charts as well as clustered column and bar charts and am wondering if there is a way to make the data labels automatically appear/disappear with changes in the data. Specifically, if the value is 0% in a pie chart, I don't want the data label to show, but as soon as it becomes >1% I want it to appear. Is there an easy way to do this versus constantly removing and re-adding the data labels?