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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to delete Excel chart legend in C#, VB.NET?

This article explains how to delete chart legend using XlsIO.

 

What is the use of chart legend?

 

Most of the charts use legend to help readers understand the charted data. Whenever a chart is created in Excel, legend for the chart is automatically generated at the same time. A chart will not have a legend if it is manually removed, but can be retrieved.

Code snippet to delete chart legend

Delete chart legend using Delete() method.

 

Applicable properties for chart legend

 

Below is the list of other common properties applicable for chart legend.

 

1.  Position

2.  IncludeInLayout

 

NOTE: Applying properties apart from the mentioned list might throw exception or the changes will not be reflected in the output document because those properties are not related to chart legend.

 

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 delete chart legend using XlsIO.

 

C#

 

VB

 

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

Please sign in to access our KB

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon 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.Close Icon