Ask Your Question
0

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

asked 2017-04-02 06:38:20 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-04-02 07:17:15 +0200

pierre-yves samyn gravatar image

Hi

  • 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.

Regards

edit flag offensive delete link more

Comments

Thank you! Worked like a charm

JazzCat gravatar imageJazzCat ( 2017-04-02 07:47:51 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-04-02 06:38:20 +0200

Seen: 785 times

Last updated: Apr 02 '17