Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating stacked bar for multiple groups and multiple years
Hello. I'm trying to create a stacked bar graph for multiple groups. I've
looked at other posts but still can't figure this out. Given the following: FY 07 Group A ATB increase = 2.5% Step increase = 0.75% Longevity increase = 0.5% Group B ATB increase = 3.5% Step increase = 0.5% Longevity increase = 1.5% Group C ATB increase = 1.5% Step increase = 1.75% Longevity increase = 0.25% FY 08 Group A ATB increase = 6.5% Step increase = 0.75% Longevity increase = 0.25% Group B ATB increase = 4.5% Step increase = 0.25% Longevity increase = 1.25% Group C ATB increase = 1.25% Step increase = 2.75% Longevity increase = 1.25% FY 09 Group A ATB increase = 1.5% Step increase = 2.75% Longevity increase = 1.25% Group B ATB increase = 2.5% Step increase = 2.25% Longevity increase = 1.25% Group C ATB increase = 4.25% Step increase = 3.75% Longevity increase = 1.25% My ultimate goal is to see Group A with the three "increase" partes as a stacked bar for FY07 and then FY08 next to it and FY09 next to that. The same for the other groups. This way, I can look at each group and see how the fiscal years are compared along with identifying the parts that make up the group. Sorry for the length. Any help is greatly appreciated! Thanks! James |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating stacked bar for multiple groups and multiple years
Hi,
Take a look at this: http://peltiertech.com/Excel/ChartsH...sterStack.html If this helps, please click the Yes button Cheers, Shane Devenshire "James" wrote: Hello. I'm trying to create a stacked bar graph for multiple groups. I've looked at other posts but still can't figure this out. Given the following: FY 07 Group A ATB increase = 2.5% Step increase = 0.75% Longevity increase = 0.5% Group B ATB increase = 3.5% Step increase = 0.5% Longevity increase = 1.5% Group C ATB increase = 1.5% Step increase = 1.75% Longevity increase = 0.25% FY 08 Group A ATB increase = 6.5% Step increase = 0.75% Longevity increase = 0.25% Group B ATB increase = 4.5% Step increase = 0.25% Longevity increase = 1.25% Group C ATB increase = 1.25% Step increase = 2.75% Longevity increase = 1.25% FY 09 Group A ATB increase = 1.5% Step increase = 2.75% Longevity increase = 1.25% Group B ATB increase = 2.5% Step increase = 2.25% Longevity increase = 1.25% Group C ATB increase = 4.25% Step increase = 3.75% Longevity increase = 1.25% My ultimate goal is to see Group A with the three "increase" partes as a stacked bar for FY07 and then FY08 next to it and FY09 next to that. The same for the other groups. This way, I can look at each group and see how the fiscal years are compared along with identifying the parts that make up the group. Sorry for the length. Any help is greatly appreciated! Thanks! James |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating stacked bar for multiple groups and multiple years
I think this'll work. Thank you!
"Shane Devenshire" wrote: Hi, Take a look at this: http://peltiertech.com/Excel/ChartsH...sterStack.html If this helps, please click the Yes button Cheers, Shane Devenshire "James" wrote: Hello. I'm trying to create a stacked bar graph for multiple groups. I've looked at other posts but still can't figure this out. Given the following: FY 07 Group A ATB increase = 2.5% Step increase = 0.75% Longevity increase = 0.5% Group B ATB increase = 3.5% Step increase = 0.5% Longevity increase = 1.5% Group C ATB increase = 1.5% Step increase = 1.75% Longevity increase = 0.25% FY 08 Group A ATB increase = 6.5% Step increase = 0.75% Longevity increase = 0.25% Group B ATB increase = 4.5% Step increase = 0.25% Longevity increase = 1.25% Group C ATB increase = 1.25% Step increase = 2.75% Longevity increase = 1.25% FY 09 Group A ATB increase = 1.5% Step increase = 2.75% Longevity increase = 1.25% Group B ATB increase = 2.5% Step increase = 2.25% Longevity increase = 1.25% Group C ATB increase = 4.25% Step increase = 3.75% Longevity increase = 1.25% My ultimate goal is to see Group A with the three "increase" partes as a stacked bar for FY07 and then FY08 next to it and FY09 next to that. The same for the other groups. This way, I can look at each group and see how the fiscal years are compared along with identifying the parts that make up the group. Sorry for the length. Any help is greatly appreciated! Thanks! James |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
100% stacked column with multiple years (3) and areas (7) | Charts and Charting in Excel | |||
Multiple Criteria to Classify groups | Excel Worksheet Functions | |||
Counting a single value across multiple cell groups | Excel Discussion (Misc queries) | |||
How to group multiple items in to three groups. | Excel Worksheet Functions | |||
MAX, MIN, MEAN, AVERAGE, MODE for multiple groups...how? | Excel Worksheet Functions |