Area

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

AreaChartSetting Options

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

Property	Type	Details
areaChartDataLabel	AreaChartDataLabel	General Data label option applied for all series
areaChartSeriesSettings	List<AreaChartSeriesSetting?>	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
areaChartTypes	AreaChartTypes	Type of chart
chartAxesOptions	ChartAxesOptions	Chart axes options

AreaChartDataLabel Options

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

Property	Type	Details
dataLabelPosition	DataLabelPositionValues	Data Label placement options.

AreaChartSeriesSetting Options

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

areaChartDataLabel	AreaChartDataLabel	Data Label Option specific to one series
fillColor	string?	Fill color specific to one series