View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Mallik Rao Mallik Rao is offline
external usenet poster
 
Posts: 1
Default 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.