public class ColumnSeries : Series 

var workbook = Workbook.Create( ChartSample.ChartSampleOutputDirectory + @"AddCharts.xlsx" );

// Gets the first Worksheet. A Workbook always contains at least 1 Worksheet.
var worksheet = workbook.Worksheets[ 0 ];

// Adds Values for Category.
worksheet.Cells[ "B4" ].Value = 2020;
worksheet.Cells[ "B5" ].Value = 2021;
worksheet.Cells[ "B6" ].Value = 2022;
worksheet.Cells[ "B7" ].Value = 2023;
worksheet.Cells[ "B8" ].Value = 2024;

// Adds Values for Series.
worksheet.Cells[ "C4" ].Value = 20d;
worksheet.Cells[ "C5" ].Value = 28d;
worksheet.Cells[ "C6" ].Value = 33d;
worksheet.Cells[ "C7" ].Value = 12d;
worksheet.Cells[ "C8" ].Value = 45d;

// Adds a BubbleChart with the generic Add method and set its SubType. The size of the Chart will be from Cell E4 to L18.
var columnChart = worksheet.Charts.Add<ColumnChart>( "E4", "L18" );
columnChart.SubType = ColumnChartSubType.Stacked;

// Sets the Chart's Title.
columnChart.Title.Text = "Profits";
columnChart.Title.TextOptions.Font.Bold = true;

// Sets the Legend.
columnChart.Legend.Position = LegendPositionType.Right;

// Sets the Category data(x values) for the ColumnChart : Cells B4 to B8.
columnChart.CategoryData = CategoryData.FromCells( worksheet, "B4", "B8" );

// Sets the space between the Columns to 50%.
columnChart.GapWidth = 50;

// Adds ColumnSeries to the ColumnChart (y values) by specifying fixed values and a range of Cells’ Adresses.
var columnSeries1 = columnChart.SeriesCollection.AddFromValues<ColumnSeries>( 5d, 10d, 15d, 20d, 40d );
columnSeries1.Name = "IBM";
var columnSeries2 = columnChart.SeriesCollection.AddFromCells<ColumnSeries>( "C4", "C8" );
columnSeries2.Name = "Apple";

// Shows the DataPoint Labels for the ColumnSeries and positions them.
columnSeries1.DataPointLabels.ShowValue = true;
columnSeries1.DataPointLabels.Position = SurfaceDataPointLabelsPositionType.InsideEnd;
columnSeries1.DataPointLabels.TextOptions.TextFill.Color = Xceed.Drawing.Color.White;
columnSeries2.DataPointLabels.ShowValue = true;
columnSeries2.DataPointLabels.Position = SurfaceDataPointLabelsPositionType.InsideBase;
columnSeries2.DataPointLabels.TextOptions.TextFill.Color = Xceed.Drawing.Color.White;

// Saves Workbook to disk.
workbook.Save();