Combo

Add chart method present in worksheet component. This type is bit different from previous core chart types. Combo setting act as organiser for adding other base type chart to single chart componenet along with additional options

Basic Code Sample

Worksheet worksheet = excel.AddSheet("Combo Chart");
CreateDataCellPayload().ToList().ForEach(rowData =>
{
	worksheet.SetRow(ConverterUtils.ConvertToExcelCellReference(++row, 1), rowData, new());
});
ComboChartSetting<ExcelSetting> comboChartSetting = new()
{
	secondaryAxisPosition = AxisPosition.TOP,
	applicationSpecificSetting = new()
	{
		from = new()
		{
			row = 21,
			column = 5
		},
		to = new()
		{
			row = 41,
			column = 20
		}
	}
};
comboChartSetting.AddComboChartsSetting(new LineChartSetting<ExcelSetting>()
{
	applicationSpecificSetting = new()
});
comboChartSetting.AddComboChartsSetting(new BarChartSetting<ExcelSetting>()
{
	isSecondaryAxis = true,
	applicationSpecificSetting = new()
});
comboChartSetting.AddComboChartsSetting(new ColumnChartSetting<ExcelSetting>()
{
	applicationSpecificSetting = new()
});
worksheet.AddChart(new()
{
	cellIdStart = "A1",
	cellIdEnd = "D4"
}, comboChartSetting);

Above code is example to add each data series as different type of chart grapics combined as combo chart

`ComboChartSetting` Options

List of supported chart that can be inserted into combo chart

PreviousScatter NextStyle