How do I add totals above the bars on a stacked bar chart?

I created a stacked bar chart and would like the display the total of all values for each stacked bar at the top of each bar.


  • Add a columnn, calculate sum and add this col. to the datarange
  • Use Columns and Lines chart type
  • Insert Data Labels for this data series and format the line to - none -

I did not mask the line in the StackChart.ods example to facilitate understanding.


Thank you! Worked like a charm