Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 72
Default stacked column with total

I created a stacked column chart with 2 series. I'd like to show the total
value on top each bar. Right now, show value displays each value of
independently. For example, I have a bar showing 3 and 2 stacked but I would
like to show 5 (3+2) on the top bar.
I've seen on someone graph before. I can't recreate it. Pls help.

Thanks
Mat
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,173
Default stacked column with total

Mat

Check here

http://andypope.info/charts/StackColTotal.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"matelot" wrote in message
...
I created a stacked column chart with 2 series. I'd like to show the total
value on top each bar. Right now, show value displays each value of
independently. For example, I have a bar showing 3 and 2 stacked but I
would
like to show 5 (3+2) on the top bar.
I've seen on someone graph before. I can't recreate it. Pls help.

Thanks
Mat


  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8
Default stacked column with total

Nick,
Your linked page worked for me! Thanks for sharing.

Kim

"Nick Hodge" wrote:

Mat

Check here

http://andypope.info/charts/StackColTotal.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


Reply
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
How do I add a total to a stacked bar graph in Excel Greg L Charts and Charting in Excel 6 November 27th 07 04:05 PM
Total on Stacked Column Chart scott Excel Discussion (Misc queries) 2 February 6th 07 12:51 PM
How do I get total value data labels in a stacked bar chart? blemerson Charts and Charting in Excel 2 September 15th 06 07:08 PM
To create a stacked column chart and group the stacked bars togeth Jacqueline Charts and Charting in Excel 1 February 17th 05 11:05 PM
total value of stacked charts OkieViking Charts and Charting in Excel 1 January 28th 05 12:57 PM


All times are GMT +1. The time now is 11:28 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"