| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a "backwards" chart | Charts and Charting in Excel | |||
| Create a custom chart, two stacked bars/month w/ two axes? | Charts and Charting in Excel | |||
| To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel | |||
| How to make a stacked bar chart using time? | Charts and Charting in Excel | |||
| How can I create a stacked bar chart with stacked bars side by | Charts and Charting in Excel | |||
Linear Mode
