Forum Discussion
Solved
Showing Data Lables on Charts
I'm creating a pie-chart of monthly sales totals with 4 categories. Is there a way to have the chart automatically display the category name and value on the chart if it's greater than zero but not ...
Hi,
Assuming sales for all of those 4 categories >= 0, then categories with value = 0 should have no impact on the pie chart.
So you can just filter out the categories with >0 values, and base your pie chart on that instead of on all categories:
I see what you did! Thanks for helping a newb out.