Hi Anne

You can add a third 'invisible' series with stacked bars as well a
stacked columns, but to avoid the additional series orienting itsel
horzontally, you'll have to use an invisible bar, not a line. This ha
a couple more steps:

Add a third series to the chart whose values are the sum of the colum
elements
Right click on the new series an set the series axis to 'secondary'.
Right click on the series again, select format data series, select th
data labels tab, check 'value'
Right click on the series again, select format data series, select th
patterns tab. set line to 'none' and pattern to 'none',
Delete the secondary axis
If necessary, delete the additional series from the legend

The attached is an exampl

             Attachment filename: stacked bar.xls            
Download attachment: http://www.excelforum.com/attachment.php?postid=46078
--
Message posted from http://www.ExcelForum.com

You can try the following:

If your values are located in A1:C10, with column A bearing the label
and columns B and C containing the series to be stacked, then ad
column D (Total), where you type =sum(Bx:Cx) to sum the value columns.

Create a staked bar graph for A1:D10
Click on data series corresponding to column D - Format Data Seires
Axis, and choose secondary axis

Now add a data label to this series - with value
Choose the data series again ->Format Data Series->Patterns ->Set lin
and area to none.

Clear the secondary axis and teh legend entry.

- Leni

--
Message posted from http://www.ExcelForum.com

Hi Anne -

To embellish Nicky's and Lenin's solutions to allow the axis scaling to
work automatically, we'll use one more column. Let A be the category
labels, B and C be the stacking values, D be a column of zeros, and E be
the sum of B and C. Make your stacked bar chart with A:D, then use Rob
Bovey's Chart Labeler or John Walkenbach's Chart Tools to add the data
in column E as data labels to the series of zeros in column D.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______