Read Axis Labels after Calculating the Chart

Possible Usage Scenarios

You can read axis labels of your chart after calculating its values using the Chart.Calculate() method. Please use the Axis.AxisLabels property for this purpose that will return the list of axis labels.

Read Axis Labels after Calculating the Chart

Please see the following sample code that loads the sample Excel file and reads the category axis labels of the chart in the first worksheet. It then prints the values of the axis labels on the console. Please see the console output of the sample code given below for a reference.

Sample Code

Console Output

 Category Axis Labels: 

---------------------

Iran

China

USA

Brazil

England

Handle Automatic Units of Chart Axis like Microsoft Excel Determine which Axis exists in the Chart