Column

Add chart method present in worksheet component. By default the anchor is at 1,1 aka A1 cell.

Basic Code Sample

C#

Worksheet worksheet = excel1.AddSheet("Column Chart");
	worksheet.AddChart(new()
	{
		cellIdStart = "A1",
		cellIdEnd = "D4"
	}, new ColumnChartSetting<ExcelSetting>()
	{
		applicationSpecificSetting = new()
		{
			from = new()
			{
				row = 5,
				column = 5
			},
			to = new()
			{
				row = 20,
				column = 20
			}
		}
	});

ColumnChartSetting Options

Contains options details extended from ChartSetting that are specific to column chart.

Property	Type	Details
columnChartDataLabel	ColumnChartDataLabel	General Data label option applied for all series
columnChartSeriesSettings	List<ColumnChartSeriesSetting?>	Data Series specific options are used from the list. The position on the list is matched with the data series position. you can use null to skip a series
columnChartTypes	ColumnChartTypes	Type of chart
chartAxesOptions	ChartAxesOptions	Chart axes options
columnGraphicsSetting	ColumnGraphicsSetting	Set properties related to bar placement

ColumnChartDataLabel Options

Contains options details extended from ChartDataLabel that are specific to column chart.

Property	Type	Details
dataLabelPosition	DataLabelPositionValues	Data Label placement options.

ColumnChartSeriesSetting Options

Contains options details extended from ChartSeriesSetting that are specific to column chart.

columnChartDataLabel	ColumnChartDataLabel	Data Label Option specific to one series
fillColor	string?	Fill color specific to one series
columnChartDataPointSettings	List<ColumnChartDataPointSetting?>	Data point specific options are used from the list. The position on the list is matched with the data point position. you can use null to skip a data point.

ColumnGraphicsSetting Options only applied in cluster type

Property	Type	Details
categoryGap	int	Gap between Category. Default : 219
seriesGap	int	Gap between Series. Default : -27

ColumnChartDataPointSetting Options

Contains options details extended from ChartDataPointSetting that are specific to column chart.