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.

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.