Chart Axis

[Roy]

Is there a way to swap axis, would like to allow the user to swap Left and Bottom Axis (data and labels)?

[Yeray]

Hi Roy,

You can set a series to use left or right axis as follows:

Code: Select all

  Series1.VertAxis:=aRightAxis;
  Series2.VertAxis:=aLeftAxis;

[Roy]

Thanks. Will this also change the axis minimum, maximum, increment, etc.?

[Sandra]

Hello Roy,

To change the properties of axes minimum,maximum,increment you need do something as next:

Code: Select all

Chart1.Axes.Left.Automatic:=False;
Chart1.Axes.Left.Maximum:=1000;
Chart1.Axes.Left.Minimum:=0;
Chart1.Axes.Left.Increment:=100;

Chart1.Axes.Right.Automatic:=False;
Chart1.Axes.Right.Maximum:=1000;
Chart1.Axes.Right.Minimum:=0;
Chart1.Axes.Right.Increment:=50;

I hope will helps.

Thanks,

[Yeray]

Hi Roy,

Just in addition to what Sandra just said:
If you don't change the axes range with SetMinMax method, nor the automatic properties, they will automatically fit the series they have assigned.
So, if you have a series using the left axis and another series using the right axis and you swap them, their ranges will also be reset to fit their new series assignment.