View Single Post
  #4   Report Post  
Jon Peltier
 
Posts: n/a
Default

Add the totals in the worksheet. Add a new series using these totals. Select this
added series, and using Chart Type on the Chart menu, change this series to a line
chart type. Double click on the new line series, and on the Patterns tab, select
None for line and markers, then on the Data Labels tab, choose the Values option.
Then double click on a label, and on the Alignment tab, choose the Above position.

You can remove the legend entry for the new series if desired: select the legend,
then click on the series name, and press the Delete key.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

bhank wrote:

I have a column chart with 3 series stacked on top of each other. Is there a
way in this chart to indicate a combined total of the values of all 3 series
at the top of the column?