How can I create a stacked bar chart with 3 bars grouped together.

I want to have a stacked bar chart, with 3 bars aranged into monthly groups.
So if I produced a yearly graph, it would contain 36 bars in total.
Im using excel 2002 (xp) and can get either a stacked bar chart, or a
grouped bar chart, but not both together.

Hi,

The secret to creating stacked clusters is your data layout.

Jon Peltier has links to examples,
http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

SteW wrote:
> I want to have a stacked bar chart, with 3 bars aranged into monthly groups.
> So if I produced a yearly graph, it would contain 36 bars in total.
> Im using excel 2002 (xp) and can get either a stacked bar chart, or a
> grouped bar chart, but not both together.

--

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

Ahhh, cheers dude

"Andy Pope" wrote:

> Hi,
>
> The secret to creating stacked clusters is your data layout.
>
> Jon Peltier has links to examples,
> http://peltiertech.com/Excel/ChartsH...sterStack.html
>
> Cheers
> Andy
>
> SteW wrote:
> > I want to have a stacked bar chart, with 3 bars aranged into monthly groups.
> > So if I produced a yearly graph, it would contain 36 bars in total.
> > Im using excel 2002 (xp) and can get either a stacked bar chart, or a
> > grouped bar chart, but not both together.
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>