Bar

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("Bar Chart");
	worksheet.AddChart(new()
	{
		cellIdStart = "A1",
		cellIdEnd = "D4"
	}, new BarChartSetting<ExcelSetting>()
	{
		applicationSpecificSetting = new()
		{
			from = new()
			{
				row = 5,
				column = 5
			},
			to = new()
			{
				row = 20,
				column = 20
			}
		}
	});

BarChartSetting Options

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

Property	Type	Details
barChartDataLabel	BarChartDataLabel	General Data label option applied for all series
barChartSeriesSettings	List<BarChartSeriesSetting?>	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
barChartTypes	BarChartTypes	Type of chart
chartAxesOptions	ChartAxesOptions	Chart axes options
barGraphicsSetting	BarGraphicsSetting	Set properties related to bar placement

BarChartDataLabel Options

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

Property	Type	Details
dataLabelPosition	DataLabelPositionValues	Data Label placement options.

barChartSeriesSetting Options

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

barChartDataLabel	BarChartDataLabel	Data Label Option specific to one series
fillColor	string?	Fill color specific to one series
barChartDataPointSettings	List<BarChartDataPointSetting?>	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.

BarGraphicsSetting Options only applied in cluster type

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

BarChartDataPointSetting Options

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