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 vertical axis crosses value for chart axis in C#, VB.NET?

This article explains how to set vertical axis crosses value for chart axis using XlsIO.

How to set vertical axis crosses value?

In an Excel chart, the horizontal (category) axis can be made to cross the vertical (value) axis using Horizontal axis crosses. Similarly, the vertical (value) axis can also be made to cross the horizontal axis using Vertical axis crosses. This can be achieved in XlsIO using CrossesAt property.

Code snippet to set vertical axis crosses value

Set the primary value axis (vertical axis) crosses value using CrossesAt.

 

The category axis can be made to cross the value axis at maximum axis value by enabling IsMaxCross property.

 

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 vertical axis crosses value using XlsIO.

 

C#

 

VB

 

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

                    Horizontal axis made to cross through vertical axis at 3.5 using XlsIO

 

Article ID: Published Date: Last Revised Date: Platform: Control:
8615 03/21/2018 03/21/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.