How can I make the legend of my bar chart display the value?

edited April 2023 in Charting

I'd like my bar chart to show how many answered "Yes" and "No" but can't seem to find where to set that. The legend only says "Yes" and "No"

I've attached a screenshot. Any help would be appreciated.

Best Answer


  • MichelleH
    MichelleH Coach
    Answer ✓

    @AAofOO Are you looking for the total number "Yes" and "No" responses or the number per month?

    For totals, I recommend using a customer summary number (

    For the number per month, you can display the value using the Data Label Settings.

  • Thanks for your reply! I'd actually like for "Yes" and "No" to display the total amount in the Legend, if that's possible.

  • @AAofOO I don't believe that's an option in the bar chart, but I know it is possible in a Pie/Donut chart type.

  • I understand. Thanks for letting me know!

  • You could get the total for each month as well as the overall total if you include a data table. This won't add the value to the legend, but will get the viewer a quick ability to see the total.

    “There is a superhero in all of us, we just need the courage to put on the cape.” -Superman