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