Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I combine stacked and clustered chart types?
I have data broken out by month (x-axis) and I want to provide quantity &
value columns for each month (using primary & secondary axis). Then I need each column (quantity & value) broken out by region. I if I use the stacked column chart, the quantity & value columns lay on top of each other. I need them side by side like the clustered column chart. But the clustered column chart won't allow me to show the region breakdown of each column. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I combine stacked and clustered chart types?
I believe this page will help
http://people.stfx.ca/bliengme/ExcelTips/Columns.htm best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Kate" wrote in message ... I have data broken out by month (x-axis) and I want to provide quantity & value columns for each month (using primary & secondary axis). Then I need each column (quantity & value) broken out by region. I if I use the stacked column chart, the quantity & value columns lay on top of each other. I need them side by side like the clustered column chart. But the clustered column chart won't allow me to show the region breakdown of each column. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I combine stacked and clustered chart types?
I have a detailed tutorial here (partially inspired by Bernard's example):
http://peltiertech.com/WordPress/clu...column-charts/ From this page I link to a utility that builds them for you. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Bernard Liengme" wrote in message ... I believe this page will help http://people.stfx.ca/bliengme/ExcelTips/Columns.htm best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Kate" wrote in message ... I have data broken out by month (x-axis) and I want to provide quantity & value columns for each month (using primary & secondary axis). Then I need each column (quantity & value) broken out by region. I if I use the stacked column chart, the quantity & value columns lay on top of each other. I need them side by side like the clustered column chart. But the clustered column chart won't allow me to show the region breakdown of each column. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I combine a stacked and clustered column chart in Excel | Charts and Charting in Excel | |||
Needed: Chart that combines clustered column and stacked column types | Charts and Charting in Excel | |||
Combined Clustered and Stacked Chart | Charts and Charting in Excel | |||
stacked and clustered chart subtypes? | Charts and Charting in Excel | |||
how to add line to stacked-clustered chart? | Charts and Charting in Excel |