Stacked bar for multiple series + secondary axis
 

Hello!
:confused: Could somebody help me to get 2 or more parallel and
distinct stacked bars? In the attached picture you will see that the
only solution I got was to modify the bar width.


Thank!!!!!!!!!!!!!!


+-------------------------------------------------------------------+
|Filename: Stacked bar.bmp |
|Download: http://www.excelforum.com/attachment.php?postid=3908 |
+-------------------------------------------------------------------+

--
gilbertcn
------------------------------------------------------------------------
gilbertcn's Profile: http://www.excelforum.com/member.php...o&userid=28113
View this thread: http://www.excelforum.com/showthread...hreadid=476233

Hi,

This example is for columns but the technique should hold true for bars.

http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

gilbertcn wrote:
Hello!
:confused: Could somebody help me to get 2 or more parallel and
distinct stacked bars? In the attached picture you will see that the
only solution I got was to modify the bar width.


Thank!!!!!!!!!!!!!!


+-------------------------------------------------------------------+
|Filename: Stacked bar.bmp |
|Download: http://www.excelforum.com/attachment.php?postid=3908 |
+-------------------------------------------------------------------+


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Stacked bar for multiple series + secondary axis
 

Thanks. It worked