T
Thao Moua [ms]
This is what you need to do.
1. create your two series and give each series an
internal name (this will be explain later)
CS.Charts(0).seriescollection(0).name = "series1"
CS.Charts(0).seriescollection(1).name = "series2"
2. (lets say you want to add a new Y value to series2)
CS.Charts(0).Seriescollection("series2").Ungroup TRUE
When you ungroup a series, the series are re-indexed,
thus series(0) may not be 'series1' anymore.
3. add a new axis and base the axis scale value on the
series2 value
set C=CS.constants
set oSeries = CS.charts(0).seriescollection("series2")
CS.Charts(0).Axes.Add oSeries.Scalings(C.chDimValues)
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
1. create your two series and give each series an
internal name (this will be explain later)
CS.Charts(0).seriescollection(0).name = "series1"
CS.Charts(0).seriescollection(1).name = "series2"
2. (lets say you want to add a new Y value to series2)
CS.Charts(0).Seriescollection("series2").Ungroup TRUE
When you ungroup a series, the series are re-indexed,
thus series(0) may not be 'series1' anymore.
3. add a new axis and base the axis scale value on the
series2 value
set C=CS.constants
set oSeries = CS.charts(0).seriescollection("series2")
CS.Charts(0).Axes.Add oSeries.Scalings(C.chDimValues)
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