We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

How to set multilevel labels for Excel chart axis in C#, VB.NET?

This article explains how to set multilevel labels in chart axis using XlsIO.

How to set multilevel labels in chart axis?

Two or more category labels can be displayed for an axis through Multi-level labels. This can be achieved in XlsIO through NoMultiLevelLabel property in category axis, where multilevel labels can be enabled or disabled in chart.

 

         C:\Users\kondurukeerthi.kondu\AppData\Local\Microsoft\Windows\INetCache\Content.Word\Capture.png

          Multilevel labels set using XlsIO

 

Code snippet to set multilevel labels

 

Note: Only chart category axis supports multilevel labels whereas value axis does not.

Applicable properties for a chart axis

Below is the list of some of the common properties that are used to format chart axis.

1.  CrossesAt

2.  NumberFormat

3.  Title

4.  IsReversed

5.  Visible

 

Download Complete Sample

 

Download input file with data

 

To know more about creating charts with various settings using XlsIO, please refer the documentation.

 

The following C#/ VB.NET complete code snippet shows how to set multilevel labels in chart axis using XlsIO.

 

C#

 

VB

 

Article ID: Published Date: Last Revised Date: Platform: Control:
8580 03/14/2018 03/14/2018 Windows Forms XlsIO
Did you find this information helpful?
Add Comment
You must log in to leave a comment

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.