How do you control what Y axis a series is bound to?

[g3000]

New to OWC and I wanted to know how you declare what Y axis a series is
bound to?

By default the values will be on the "left" Y axis but suppose you want
to declare another Y axis to the right but you only want some series to
bound to that?

My left Y axis would be whole numbers. My second Y axis would be a
percentage.

Some series should bind to the "left" Y axis and some to the "right" Y
axis.

Thank you for your time.

 

[Alvin Bruney - ASP.NET MVP]

If I understand you correctly, that functionality is not supported

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006

 

[g3000]

Alvin I know you know your stuff but can you briefly see why a
Microsoft Product Support Services tech ( Wei-Dong Xu )

gave this VB example?

http://groups.google.com/group/micr...+Web+Component+Y+Axis&rnum=2#435be9c0aa66fe9e

thanks for your time

 

[Alvin Bruney - ASP.NET MVP]

Wei-Dong is correct. I'm not.
I either didn't know what I was talking about or didn't understand you
correctly.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006

 

[mc2006]

Hi g3000,
Following your message I also have some trouble with two series that I
want to show in the chart in 2 different y-axis.

I've reproduced the example that you mentioned but I came across a
problem: I want one of the series (let's say the one with the left
axis) as a chChartTypeLine and the other as a chChartTypeBarClustered.
But, I can't get that working!

The code:

'serie on the left
oSer1 = m_Chart.SeriesCollection.Add
oSer1.Type = OWC11.ChartChartTypeEnum.chChartTypeLine

oSer1.SetData(OWC11.ChartDimensionsEnum.chDimSeriesNames, -1,
"MySeries 1")
oSer1.SetData(OWC11.ChartDimensionsEnum.chDimCategories, -1, aCats)
oSer1.SetData(OWC11.ChartDimensionsEnum.chDimValues, -1, aVals)

'serie on the right
oSer2 = m_Chart.SeriesCollection.Add
oSer2.Ungroup(True)

'to scale both
oSer1.Group(oSer2)

'create right axis
axis =
m_Chart.Axes.Add(oSer2.ScalingsOWC11.ChartDimensionsEnum.chDimValues))
axis.Position = OWC11.ChartAxisPositionEnum.chAxisPositionRight

oSer2.SetData(OWC11.ChartDimensionsEnum.chDimSeriesNames, -1,
"MySeries 2")
oSer2.SetData(OWC11.ChartDimensionsEnum.chDimCategories, -1, aCats)
oSer2.SetData(OWC11.ChartDimensionsEnum.chDimValues, -1, aVals2)
oSer2.Type = OWC11.ChartChartTypeEnum.chChartTypeBarClustered


I get 2 bar graphs sitted on the left axis.
Any ideas? Thanks a lot.

 

[g3000]

mc2006,
To be honest, I ditched OWC altogether. Im using VS 2005
and OWC is disabled. I get the feeling Microsoft is NOT trying to back
OWC going forward. Especially since COM objects is are viewed as the
plague by MS now. I was trying to create charts for the web.
I just used www.dotnetcharting.com. The customer Im doing the work for
will pay for it.

Maybe someone else has an idea.