Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Column Chart Challenge
I need to creat a stacked column chart, but need the columns to be one in
front of another, vs either stacked next to one another on top of one another. The closest I have come is to do the chart in 3D and pivot the corners of the area so the columns are mostly one in front of another. Have run out of ideas and not coming up with a good solution - any suggestions? Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Column Chart Challenge
If they are one in front of the other, they are not stacked.
Make a clustered column chart, then format one of the series and play with the Overlap setting. 100 means they overlap 100% and thy are perfectly aligned. 50% means the ones in front only obscure half the width of the ones in back. You have to take care that the bars in front aren't taller than those in back or you'll lose sight of some of the data. Even if the taller bars are in back, partially obscuring them partially obscures the meaning of the chart. - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "debra49424" wrote in message ... I need to creat a stacked column chart, but need the columns to be one in front of another, vs either stacked next to one another on top of one another. The closest I have come is to do the chart in 3D and pivot the corners of the area so the columns are mostly one in front of another. Have run out of ideas and not coming up with a good solution - any suggestions? Thanks |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Column Chart Challenge
Thanks for the help -- it let me give my boss the chart the way he wanted it.
"debra49424" wrote: I need to creat a stacked column chart, but need the columns to be one in front of another, vs either stacked next to one another on top of one another. The closest I have come is to do the chart in 3D and pivot the corners of the area so the columns are mostly one in front of another. Have run out of ideas and not coming up with a good solution - any suggestions? Thanks |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Column Chart Challenge
Gotta keep the boss happy.
- Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - June 17-18 2009 - Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "debra49424" wrote in message ... Thanks for the help -- it let me give my boss the chart the way he wanted it. "debra49424" wrote: I need to creat a stacked column chart, but need the columns to be one in front of another, vs either stacked next to one another on top of one another. The closest I have come is to do the chart in 3D and pivot the corners of the area so the columns are mostly one in front of another. Have run out of ideas and not coming up with a good solution - any suggestions? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Chart Title With 3D Stacked Column Chart | Charts and Charting in Excel | |||
Excel 2003 - Combination chart: Stacked Column + Stacked Column | Charts and Charting in Excel | |||
Needed: Chart that combines clustered column and stacked column types | Charts and Charting in Excel | |||
How can I add a line chart in a stacked column chart style? | Excel Discussion (Misc queries) | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel |