Sum on top of stacked columns

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

César

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

display total in stacked column chart 3
Creating Stacked Columns Chart 1
Total of Stacked Column Chart 1
stacked column chart but label with %? 1
Stacked column graphs and text displayed inside the columns 1
Stacked column-chart Excel 2007 1
Stacked 3D Bar graph 1
Stacked Column Chart - Total that isn't the sum of series 1

Top