ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   how do I create a stacked bar chart on 2 axis (https://www.excelbanter.com/charts-charting-excel/85139-how-do-i-create-stacked-bar-chart-2-axis.html)

peterhall99

how do I create a stacked bar chart on 2 axis
 
I'd like to create a stacked bar chart showing two stacked bars (Forecast and
Actual), however I can only get excel to produce 1 stacked bar. Is there a
way of displaying two stacked bars side by side?

Andy Pope

how do I create a stacked bar chart on 2 axis
 
Hi,

See Jon Peltier's page on cluster stacked column chart.
http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

peterhall99 wrote:
I'd like to create a stacked bar chart showing two stacked bars (Forecast and
Actual), however I can only get excel to produce 1 stacked bar. Is there a
way of displaying two stacked bars side by side?


--

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

peterhall99

how do I create a stacked bar chart on 2 axis
 
Andy,

Many thanks, the link gave me exactly what I was looking for.

Cheers...Peter

"Andy Pope" wrote:

Hi,

See Jon Peltier's page on cluster stacked column chart.
http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

peterhall99 wrote:
I'd like to create a stacked bar chart showing two stacked bars (Forecast and
Actual), however I can only get excel to produce 1 stacked bar. Is there a
way of displaying two stacked bars side by side?


--

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



All times are GMT +1. The time now is 08:05 PM.

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