LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 447
Default How do I add a total to a stacked bar graph in Excel

Jon:

Thank you so much...........this is brilliant!!! It works like a charm.
Even though you posted this 2 years ago or more it has saved my sanity.
Thanks again I hope you have a wonderful HOLIDAY SEASON.

Karen Martin, Charleston, WV

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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A stacked, clustered bar graph? Robyn Charts and Charting in Excel 1 April 10th 05 02:03 PM
How do I show negative numbers on a stacked graph JMZ Charts and Charting in Excel 3 February 26th 05 03:21 PM
total value of stacked charts OkieViking Charts and Charting in Excel 1 January 28th 05 12:57 PM
Subtotal of Subtotal displays Grand Total in wrong row Thomas Born Excel Worksheet Functions 5 January 6th 05 01:46 PM
Can I use side by side colums and stacked columns in same graph? Debbie Charts and Charting in Excel 1 December 29th 04 06:01 PM


All times are GMT +1. The time now is 02:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"