Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Column with Secondary Axis
May any one can help me?
I am creating a Stacked Column chart with the following Data of Sugar Cane and Sugar Produced (Figuras in Tonnes) for 3 years: 2003-04 2004-05 2005-06 Region SugarCane Sugar SugarCane Sugar SugarCane Sugar North 1,110,000 91,000 1,600,000 140,000 2,100,000 180,000 Central 1,200,000 85,000 1,500,000 142,000 2,200,000 175,000 South 800,000 60,000 1,100,000 92,000 2,400,000 100,000 My requirement is, All the data to be plotted on one graph - Stacked Column Primary Axis - Sugar Cane Secondary Axis - Sugar Grouped by year I am able to create two different graphs for Sugar Cane and Sugar and unable to create single graph with 2 axis. Regards, -- Mallik Rao IT Manager Nghe An Tate & Lyle Sugar Co Ltd., VIETNAM. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Column with Secondary Axis
It's in the way you arrange your data. It's a stacked column chart, with
gaps in the Sugarcane series where the Sugar columns go, and vice versa. http://peltiertech.com/Excel/ChartsH...sterStack.html Once you've made the chart, switch the Sugar series to the secondary axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Mallik Rao" wrote in message ... May any one can help me? I am creating a Stacked Column chart with the following Data of Sugar Cane and Sugar Produced (Figuras in Tonnes) for 3 years: 2003-04 2004-05 2005-06 Region SugarCane Sugar SugarCane Sugar SugarCane Sugar North 1,110,000 91,000 1,600,000 140,000 2,100,000 180,000 Central 1,200,000 85,000 1,500,000 142,000 2,200,000 175,000 South 800,000 60,000 1,100,000 92,000 2,400,000 100,000 My requirement is, All the data to be plotted on one graph - Stacked Column Primary Axis - Sugar Cane Secondary Axis - Sugar Grouped by year I am able to create two different graphs for Sugar Cane and Sugar and unable to create single graph with 2 axis. Regards, -- Mallik Rao IT Manager Nghe An Tate & Lyle Sugar Co Ltd., VIETNAM. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? | Charts and Charting in Excel | |||
How do I do a combination STACKED column and line chart on 2 axis | Charts and Charting in Excel | |||
Can I put a secondary axis on a 3-D column chart in MS Excel? | Charts and Charting in Excel | |||
Stacked bar for multiple series + secondary axis | Charts and Charting in Excel | |||
Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel |