Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Make your chart more effective
I am trying to duplicate the bar layout of the chart displayed in the "Make
Your Chart More Effective" at Microsoft.com/training. I cannot seem to get the bars to group as three's. My chart only displays invidivual bars. It works for my 2 x 4 chart where I end up with 4 groups of 2 bars, but I need 12 groups of 2 stacked bars. Any help? Thank you. -- Connie |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Make your chart more effective
The page I found that had that phrase in it had only clustered column
charts. (Plus those 3D column charts, which are not at all effective.) You mentioned stacked bars. How should they look? Excel doesn't do stacked-clustered columns, but it's possible to get the same effect with some careful data arrangements: Clustered-Stacked Column Charts - http://peltiertech.com/WordPress/clu...column-charts/ - Jon ------- Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Connie" wrote in message ... I am trying to duplicate the bar layout of the chart displayed in the "Make Your Chart More Effective" at Microsoft.com/training. I cannot seem to get the bars to group as three's. My chart only displays invidivual bars. It works for my 2 x 4 chart where I end up with 4 groups of 2 bars, but I need 12 groups of 2 stacked bars. Any help? Thank you. -- Connie |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Make your chart more effective
John, thank you very, very much. This is exactly what I wanted. I must admit
though, I am stuck at selecting a series and moving it. -- Connie "Jon Peltier" wrote: The page I found that had that phrase in it had only clustered column charts. (Plus those 3D column charts, which are not at all effective.) You mentioned stacked bars. How should they look? Excel doesn't do stacked-clustered columns, but it's possible to get the same effect with some careful data arrangements: Clustered-Stacked Column Charts - http://peltiertech.com/WordPress/clu...column-charts/ - Jon ------- Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Connie" wrote in message ... I am trying to duplicate the bar layout of the chart displayed in the "Make Your Chart More Effective" at Microsoft.com/training. I cannot seem to get the bars to group as three's. My chart only displays invidivual bars. It works for my 2 x 4 chart where I end up with 4 groups of 2 bars, but I need 12 groups of 2 stacked bars. Any help? Thank you. -- Connie |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Make your chart more effective
I'm not sure what you mean, but I will admit that these charts are hard to
make and harder to update. - Jon ------- Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Connie" wrote in message ... John, thank you very, very much. This is exactly what I wanted. I must admit though, I am stuck at selecting a series and moving it. -- Connie "Jon Peltier" wrote: The page I found that had that phrase in it had only clustered column charts. (Plus those 3D column charts, which are not at all effective.) You mentioned stacked bars. How should they look? Excel doesn't do stacked-clustered columns, but it's possible to get the same effect with some careful data arrangements: Clustered-Stacked Column Charts - http://peltiertech.com/WordPress/clu...column-charts/ - Jon ------- Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Connie" wrote in message ... I am trying to duplicate the bar layout of the chart displayed in the "Make Your Chart More Effective" at Microsoft.com/training. I cannot seem to get the bars to group as three's. My chart only displays invidivual bars. It works for my 2 x 4 chart where I end up with 4 groups of 2 bars, but I need 12 groups of 2 stacked bars. Any help? Thank you. -- Connie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Effective Annual Interest Rate | Excel Worksheet Functions | |||
More effective than DAYS360? | Excel Worksheet Functions | |||
Effective Rate of Return | Excel Discussion (Misc queries) | |||
faster, more effective scenario analysis? | Excel Discussion (Misc queries) | |||
effective gross income | Excel Worksheet Functions |