Forum Discussion

dlkeith76's avatar
dlkeith76
Copper Contributor
Feb 18, 2024
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 if the value is zero?

 

Thanks for the help!

Darrell

Charting
excel
  • rachel's avatar
    rachel
    Feb 18, 2024

    dlkeith76 

    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:

     

     

  • rachel's avatar
    rachel
    Steel Contributor
    Feb 18, 2024

    dlkeith76 

    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:

     

     

    • dlkeith76's avatar
      dlkeith76
      Copper Contributor
      Feb 18, 2024
      I see what you did! Thanks for helping a newb out.

Resources