Show / Hide Table of Contents

Set and format the Category Axis Title

Set the category axis title text as "Category Title" and set the font size to 16 and the color to red.

Output: CategoryAxisTitle.xlsx

var workbook = new Workbook();
var worksheet = workbook.Worksheets[0];

worksheet.GetRange("J1:L1").SetValue(new[] { "Series 1", "Series 2", "Series 3" });
worksheet.GetRange("I2:I5").SetValue(new[] { "Point 1", "Point 2", "Point 3", "Point 4" });
worksheet.GetRange("J2:J5").SetValue(new[] { 2, 4, 6, 8 });
worksheet.GetRange("K2:K5").SetValue(new[] { 4, 3, 2, 1 });
worksheet.GetRange("L2:L5").SetValue(new[] { 2, 1, -1, -2 });

var chart1 = worksheet.Charts.Add<BarChart>("A1");
chart1.ChartType = ChartType.Column;
chart1.Size.HeightInches = 2.5;
chart1.Size.WidthInches = 3.5;
chart1.DataSource = "Sheet1!$I$1:$L$5";

chart1.CategoryAxis.Title = new Title();
            
chart1.CategoryAxis.Title.FormattedText.Font.Size = 16;
chart1.CategoryAxis.Title.FormattedText.Font.DrawingColor = DrawingColor.Red;
chart1.CategoryAxis.Title.FormattedText.Text = "Category Title";

workbook.SaveAs("CategoryAxisTitle.xlsx");
Back to top Generated by DocFX