This article explains how to create combination chart in Excel using XlsIO.
What is a combination chart?
Combination charts combine two or more chart types to make the data easy to understand. These charts can be used charts when the numbers in your data vary widely from data series to data series, or you have mixed type of data.
Combination chart created using XlsIO
To create a combination chart in Excel using XlsIO, you need to do the following steps.
Steps to create combination chart
Create a chart object by calling the worksheet.Charts.Add method.
Set a range of data from the worksheet to chart’s DataRange property. To plot the series values in column and categories in row, set chart’s IsSeriesInRows property to false.
Set different SerieType value to the series. By doing this, chart type will be changed to combination chart type.
Note: For creating a combination chart, the chart must have minimum two series. Setting different SerieType property or UsePrimaryAxis property, the chart will be changed to combination chart type.
Add the basic elements like chart title, data labels and legend.
Applicable ExcelChartType enum types to create combination chart using XlsIO
Below is the list of ExcelChartType enum values can be applied to the series to create a combination chart.
The following C#/ VB.NET complete code snippet shows the creation of combination of clustered column and line on secondary axis chart using XlsIO.
|Article ID:||Published Date:||Last Revised Date:||Platform:||Control:|