ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   stacked column with total (https://www.excelbanter.com/charts-charting-excel/135895-stacked-column-total.html)

matelot

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

Nick Hodge

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



kimdnw

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




All times are GMT +1. The time now is 07:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com