Charts

Essential XlsIO has advanced support for creating and modifying MS Excel charts inside a workbook. There is an option to choose between creating a chart as an 'Embedded Chart' or as a 'Worksheet Chart'.

Embedded Chart

Essential XlsIO has APIs to create an embedded chart. The IChartShape interface represents the embedded chart in-memory and this object can be used to format and modify the chart settings. This is similar to modifying chart properties using MS Excel.

There is also advanced support for formatting the Primary and Secondary chart Axis.

Worksheet Chart

You can also create a 'Worksheet Chart', where a single chart is rendered on the entire worksheet. The IChart interface is the in-memory representation of a Worksheet Chart in an MS Excel workbook. Several formatting options are also available to customize the appearance of such charts.

Essential XlsIO has several options to customize the appearance of chart elements like chart type, 3D effects, axis range, axis title format, and legend position.

You can provide a 3D-effect to different chart types as illustrated below:

Set up the range of the value axis as illustrated below:

There are options to customize the chart title and axes titles.

The chart legend can be positioned differently.

Though Essential XlsIO provides several APIs to create a chart programatically, it still does not provide all customization capabilities of MS Excel.

However, you can create a template XLS file with a defined chart customized using MS Excel, and then Essential XlsIO can write content into this template file and preserve the chart.