How to draw primary & secondary Y-axis with different scalings using OWC11

K

koushik

Hai,
My problem is I have to draw the primary and secondary
Y-Axes with different scalings using OWC11.
Iam getting that using the excel,by using the chart type
line-column 2axis chart. But I want to draw the chart
using COl2 and Col3 on primary and secondary Axis
respectively, with different scalings,by using the OWC11.

My data is looks like:

COl1 Col2 Col3
name1 10 20000
name2 5 40000
name3 20 30000

I want to represent the Col2 on primary Y-Axis with the
scaling range from 0-50.
and i want to represent the Col3 on secondary Y-axis with
the scaling range from 10000 to 50000.
is it possible to represent in a chart form this using
OWC11. Is it possible to represent the Col2 in different
chart type and Col3 in different chart type,like i excel
we are having line-column on 2-axis chart.
i.e Col2 in LineChart and Col3 in Column Chart with the
respective scalings.
Please tell me how to do programming using the OWC11.
Thank you in adavnce,
regards,
koushik
 
A

Alvin Bruney [MVP]

yes it is possible.
set the scaling minimum and maximum property of the axis to whatever you
like
then you need to ungroup the series so that they can have separate scales
from script
series.Ungroup true
axis1.scaling.maximum = 40
roughly
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top