Adds an axis to a chart. Creates a new, uninitialized WCAxis object with all properties set to Automatic. You must assign a scaling, position, and type to each added axis.
Syntax
expression.Add(Scaling, Pos, Type)
expression An expression that returns a WCAxes object.
Scaling Required WCScaling object. A scaling object from another axis or series.
Pos Required ChartAxisPositionEnum. Specifies the new axis position. For more information, see the Position property for the WCAxis object.
Type Required ChartAxisTypeEnum. Specifies the new axis type. For more information, see the Type property for the WCAxis object.
Remarks
A chart can contain no more than eight axes.