Problem in setting Position for bottom axis
Posted: Wed Nov 30, 2005 11:44 am
Hi everybody,
I want to create two different series in a single Chart object. For that i am trying to use custom axis. I used the following code
Chart.AddSeries 14
a = Chart.Axis.AddCustom(false)
Chart.Axis.Left.EndPosition = 49
Chart.Axis.Bottom.Position = 49
Chart.Axis.Custom(0).StartPosition = 52
Chart.Axis.Custom(0).Otherside = True
Cno = Chart.SeriesCount-1
Chart.Series(Cno).VerticalAxisCustom = a
b = Chart.Axis.AddCustom(true)
Chart.Series(0).HorizontalAxisCustom = b
But it gives
"Wrong number of arguments or invalid property assignment: 'Axis.Bottom.Position' "
error.
Pls help me to solve
I want to create two different series in a single Chart object. For that i am trying to use custom axis. I used the following code
Chart.AddSeries 14
a = Chart.Axis.AddCustom(false)
Chart.Axis.Left.EndPosition = 49
Chart.Axis.Bottom.Position = 49
Chart.Axis.Custom(0).StartPosition = 52
Chart.Axis.Custom(0).Otherside = True
Cno = Chart.SeriesCount-1
Chart.Series(Cno).VerticalAxisCustom = a
b = Chart.Axis.AddCustom(true)
Chart.Series(0).HorizontalAxisCustom = b
But it gives
"Wrong number of arguments or invalid property assignment: 'Axis.Bottom.Position' "
error.
Pls help me to solve