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

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - How can I create a stacked bar chart with 3 bars grouped together. (https://www.excelbanter.com/charts-charting-excel/20561-how-can-i-create-stacked-bar-chart-3-bars-grouped-together.html)

SteW

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.

Andy Pope

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

SteW

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

All times are GMT +1. The time now is 06:08 AM.