How can I create a chart with two groups of data having different Y axis value ?

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
 
Top