Manage Axes of Excel Charts

In Excel charts, there are three 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 also allows you to manage a chart’s axes at runtime. With the Axis object, you can change all options of an axis as done 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