Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Is there a way to add totals to stacked bar charts in Next Gen Presentations?




  • Official comment

    Hi Nicole!

    Wanted to let you know that a recent release to Workiva has now made total labels available in next gen Charts. Thanks for your patience and input, they were both greatly appreciated. If you have any questions, let me know. Take care and have a Happy St. Patrick's Day!

  • Mike

    Hello Nicole!

    Currently in next gen Charts, total labels are not yet there. However they are actively being worked on by our Product Team and I've shared your request with them, which you can follow along here:

    In the meantime, I also have a workaround to share to get you through in the meantime. Here's the steps outlined by our team.

    Workaround Summary: Add a line series which is a SUM of all the values in the stack, then hide the line/marker/legend item.

    1. Add a new series to your chart; Call it "Total Labels"
    2. For each cell in the "Total Labels" series, use a SUM formula and sum up all the cells needed to create a total.
    3. Make the "Total Label" series a "Line" plot type
    4. Make sure "Total Label" series has "show labels" enabled; these are your work-around total labels
    5. Hide the Line and markers for the "Total Labels" series
    6. Hide the legend item for "Total Labels" in the legend. (Do this by unchecking "show in legend" for the "Total Labels" series in the Series Section.
    NOTE: This only works if none of the stacked column/bar series have a mixture of positive and negative values; values need to be all positive or negative (for negative values, position the total labels at 'bottom' so they show below the stacked columns).

    Let me know what questions you have, or if you need anything else. Thanks so much for your feedback. Have a super day in the meantime. Cheers!

Please sign in to leave a comment.