This article explains how to convert chart created with external data range using XlsIO in C#/VB.NET.
What is chart with external data?
The chart created with the data from an external workbook is called chart with external data. The chart from the current worksheet holds a chart cache to maintain the chart data. For conversion, ExcelChartToImageConverter uses that cache information when the chart is created with external data range. By default, XlsIO does not parse the chart cache information. So, we must set the IsChartCacheEnabled property to true in IApplication to parse that cache information before opening the excel file. After parsing the cache information, it is used for converting the chart properly.
To convert chart created with external data range, you need to follow the below steps.
Steps to convert chart with external data range
The following C#/VB.NET complete code snippet shows how to convert chart with external data range.
The below screenshot shows the output chart with external data range after conversion.
|Article ID:||Published Date:||Last Revised Date:||Platform:||Control:|