how do I create a stacked bar chart on 2 axis>

's Computer Specifications

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?

's Computer Specifications

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

's Computer Specifications

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
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding line chart w/ 2nd axis to stacked bar chart	Greg Yedinak	Microsoft Excel Charting	0	12th Jan 2009 10:13 PM
Double-stacked Bar Chart WITH a Secondary Y Axis Line chart?	=?Utf-8?B?bHBlbm5kb3Jm?=	Microsoft Excel Charting	1	7th Feb 2007 04:32 PM
Create stacked columns chart but with 2 columns for each x axis?	=?Utf-8?B?UFNN?=	Microsoft Excel Charting	2	7th May 2005 03:56 PM
To create a stacked column chart and group the stacked bars togeth	=?Utf-8?B?SmFjcXVlbGluZQ==?=	Microsoft Excel Charting	1	17th Feb 2005 11:05 PM
How can I create a stacked bar chart with stacked bars side by si.	=?Utf-8?B?QnJlbmRh?=	Microsoft Excel Charting	3	22nd Jan 2005 02:09 AM