If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combine clustered column with stacked column?
Is it possible to combine a stacked and clustered column chart?
I have 12 series with 9 categories. For each of the 9 categories, I want 4 clustered columns, each one of the four a stacked column of 3 of the series. I haven't figured out how to do this yet. Is this possible and if so, how? Thanks, Eric |
#2
|
|||
|
|||
Combine clustered column with stacked column?
Eric -
You can make a clustered stacked column chart through clever arrangement of your data in the worksheet. See the details at Stephen Bullen's site: http://www.bmsltd.co.uk/Excel/SBXLPage.asp#Charting and look at the description for FunChart4 or at Bernard Liengme's site: http://www.stfx.ca/people/bliengme/E...ps/Columns.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ Eric Stewart wrote: Is it possible to combine a stacked and clustered column chart? I have 12 series with 9 categories. For each of the 9 categories, I want 4 clustered columns, each one of the four a stacked column of 3 of the series. I haven't figured out how to do this yet. Is this possible and if so, how? Thanks, Eric |
Thread Tools | |
Display Modes | |
|
|