public class ValueAxis : Axis 

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 = new DateTime( 2020, 1, 1 );
worksheet.Cells[ "B5" ].Value = new DateTime( 2021, 1, 1 ); ;
worksheet.Cells[ "B6" ].Value = new DateTime( 2022, 1, 1 );
worksheet.Cells[ "B7" ].Value = new DateTime( 2023, 1, 1 );
worksheet.Cells[ "B8" ].Value = new DateTime( 2024, 1, 1 );
 
// Adds Values for Series.
worksheet.Cells[ "C4" ].Value = 2000;
worksheet.Cells[ "C5" ].Value = 2800;
worksheet.Cells[ "C6" ].Value = 3300;
worksheet.Cells[ "C7" ].Value = 1200;
worksheet.Cells[ "C8" ].Value = 4500;

// Adds a LineChart with the generic Add method and set its SubType. The size of the Chart will be from Cell E4 to L18.
var lineChart = worksheet.Charts.Add<LineChart>( "E4", "L18" );
lineChart.SubType = LineChartSubType.LineWithMarkers;

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

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

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

// Adds LineSeries to the LineChart (y values) by specifying fixed values and a range of Cells’ Adresses.
var lineSeries1 = lineChart.SeriesCollection.AddFromValues<LineSeries>( 500, 1000, 1500, 2000, 4000 );
lineSeries1.Name = "IBM";
var lineSeries2 = lineChart.SeriesCollection.AddFromCells<LineSeries>( "C4", "C8" );
lineSeries2.Name = "Apple";

// Customizes the Category and Value Axis Line.       
lineChart.CategoryAxis.Line.Color = Xceed.Drawing.Color.Red;
lineChart.ValueAxis.Line.Color = Xceed.Drawing.Color.Blue;
lineChart.ValueAxis.Line.Width = 3d;

// Sets the minimum value of the ValueAxis.
lineChart.ValueAxis.Minimum = 5;

// Sets where the CategoryAxis will cross the ValueAxis.
lineChart.ValueAxis.CrossPositionType = CrossPositionType.Minimum;

// Shows the Major Tickmarks on the ValueAxis.
lineChart.ValueAxis.MajorTickMarksType = TickMarksType.Outside;

// Sets the ValueAxis values in reversed order.
lineChart.ValueAxis.IsReversed = true;

// Sets the ValueAxis display units.
lineChart.ValueAxis.DisplayUnits = AxisDisplayUnitsType.Hundreds;

// Shows the minor and major gridlines on the ValueAxis.
lineChart.ValueAxis.MinorGridLines.IsVisible = true;
lineChart.ValueAxis.MajorGridLines.IsVisible = true;

// Customizes & formats the ValueAxis Labels to display only whole values.
lineChart.ValueAxis.TickLabels.TextFill.Color = Xceed.Drawing.Color.Blue;
lineChart.ValueAxis.TickLabels.CustomFormat = "00";

// Sets and customizes the ValueAxis’ Title.
lineChart.ValueAxis.Title.IsVisible = true;
lineChart.ValueAxis.Title.Text = "Hundreds of $";
lineChart.ValueAxis.Title.TextOptions.TextFill.Color = Xceed.Drawing.Color.Blue;
lineChart.ValueAxis.Title.TextOptions.Font.Size = 15;
lineChart.ValueAxis.Title.TextOptions.Font.Bold = true;

// Fills the TickLabels on the Value Axis.
lineChart.ValueAxis.Fill.Color = Xceed.Drawing.Color.LightGray;

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