ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Multiple stacked clustered bars (https://www.excelbanter.com/charts-charting-excel/244775-multiple-stacked-clustered-bars.html)

Karrie

Multiple stacked clustered bars
 
I am trying to create a bar chart in Excel 2003 that has multiple stacked
clustered bars. I did some searching on the internet and it appears there
are a lot of people wanting the same thing. I cannot find an easy solution.
I am wondering whether there is an Excel add-on that can do this?
Excel can make multiple bars and stacked bars but cannot combine the two. I
have frequently had a need to perform multiple clustered stacked graphs.


Ed Ferrero[_3_]

Multiple stacked clustered bars
 
Hi karrie,

I am trying to create a bar chart in Excel 2003 that has multiple stacked
clustered bars.


The secret is to leave some blanks in your data.

See
http://peltiertech.com/WordPress/clu...column-charts/
and
http://www.andypope.info/charts/stackside.htm

Ed Ferrero
www.edferrero.com


All times are GMT +1. The time now is 03:56 AM.

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