Manage Axes of Excel Charts

In Excel charts, there are 3 kinds of Axes:

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

Axis Options

Aspose.Cells also allows to manage chart’s axes at runtime，with Axis object, you can change all options of Axis as done in Excel.

||

Manage X and Y Axes

In Excel chart, horizonal and vertical axes are the two most popular axes to use.

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

Advance 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