|
Posted to microsoft.public.excel.charting
|
|
|
How do I add a total to a stacked bar graph in Excel
Even now very helpful!!
"Jon Peltier" wrote:
Greg -
Easiest of all. Plot the individual values and the totals in the chart.
Select the Totals series, and using Chart Type on the Chart menu, change
it to a Line style. Then double click the Totals series to format it. On
the Patterns tab, choose None for lines and for markers, so it's
invisible; on the Data Labels tab, choose Show Values. Press OK to close
the dialog and apply the formats. Double click on the data labels, and
on the Alignment tab choose the Above option.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Greg L wrote:
I am using Excel for some graphs in Powerpoint and we are using stacked bar
graphs. Does anyone know how to add a total on a stcaked graph? I can add
individual values but I am looking for total per bar.
|