Manage Axes of Excel Charts

In Excel charts, there are 3 kinds of Axes:

1. Horizontal (Category) Axis: X Axis
2. Vertical (Value) Axis: Y Axis
3. Depth (Series) Axis: Z Axis

Axis Options

Aspose.Cells for Python via .NET also allows you to manage charts' axes at runtime, with the Axis object you can change all options of the axis as in Excel.

||

Manage X and Y Axes

In an Excel chart, horizontal and vertical axes are the two most commonly used axes.

The following code snippet demonstrates how to set the options of X and Y axes.

Advanced topics

• Change Tick Label Direction
• Determine which Axis exists in the Chart
• Handle Automatic Units of Chart Axis like Microsoft Excel
• Read Axis Labels after Calculating the Chart
• How to Set Category Axis in Excel Chart