ChartSpace right and left axis values

[Kevin]

Can you tell me how to add the right Y axis? Thanks

 

[Dorte]

This code adds the right axis to the chart with the same
values as the left axis.

Dim ch = ChartSpace1.Charts(0).SeriesCollection(1).Scalings
(ChartDimensionsEnum.chDimValues)

Dim objAxis = ChartSpace1.Charts(0).Axes.Add(ch,
ChartAxisPositionEnum.chAxisPositionRight,
ChartAxisTypeEnum.chValueAxis)

 

[kevin]

You need to add this before you create right axis.

ChartSpace1.Charts(0).SeriesCollection(1).Ungroup true

That is to say you can assign the series to an axis that
is based on a different value scale.

Then
You can add
Set axIncomeAxis = ChartSpace1.Charts(0).Axes.Add
(ChartSpace1.Charts(0).SeriesCollection(1).Scalings
(chConstants.chDimValues))
axIncomeAxis.Position = chConstants.chAxisPositionRight

It WILL work.

 

[Thao Moua [ms]]

Dorte, the code will not work for you since you are using
OWC9. The code will only for for OWC10 or greater.

Thao Moua
OWC Webchart Support

This posting is provided "AS IS" with no warranties, and
confers no rights. Use of included script samples are
subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

 

[Guest]

Does that mean that the only solution is to use OWC10?

Dorte

 

[Thao Moua [ms]]

Yes.

Thao Moua
OWC Webchart Support

This posting is provided "AS IS" with no warranties, and
confers no rights. Use of included script samples are
subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm