Sum on top of stacked columns

  • Thread starter Thread starter Drews
  • Start date Start date
D

Drews

Is it possible in some way to add the sum of series on top of each
column in a stacked column diagram?

I am often using this feature in ThinkCell for my powerpoint slides.
However, need to insert a stacked column graph from Excel 2007 into
Word 2007. Currently, I've been using a text box with a reference.
However, the reference in a text box is static, which makes it a
source for error when inserting or deleting rows in Excel.
 
Hello Drews.

You can add a new series with the total sum and then:

Change the chart type to line ONLY for this series.
Format the series without lines or markers.
Use the series values to rotulate the series.
In the series properties select 'second axis'.
Set the appropriate scale for the second axis.
Hide the second axis.

Regards, César.
 
Back
Top