The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.

How to: Display the Chart Title

  • 2 min to read

After you create a chart, you can display its title (a text header that explains the purpose of a chart). By default, the chart title is displayed at the top of the chart.

SpreadsheetChart_ChartTitle

To add the chart title, utilize the ChartObject.Title property, which provides access to the ChartTitle object. This object defines the main chart title and inherits basic title settings from the ChartTitleOptions and ChartText interfaces, which contain members used to display the title and specify its contents. Set the ChartTitleOptions.Visible property to true to add the title, and then do one of the following.

You can also format the chart title by changing its font, color, size or location. For information on how to change the format options of chart elements, refer to the How to: Format Chart Elements example.

Worksheet worksheet = workbook.Worksheets["chartTask2"];
workbook.Worksheets.ActiveWorksheet = worksheet;

// Create a chart and specify its location.
Chart chart = worksheet.Charts.Add(ChartType.BarClustered, worksheet["B4:C7"]);
chart.TopLeftCell = worksheet.Cells["E3"];
chart.BottomRightCell = worksheet.Cells["K14"];

// Display the chart title and specify the title text.
chart.Title.Visible = true;
chart.Title.SetValue("Market share Q3'13");

// Hide the chart legend.
chart.Legend.Visible = false;
// Specify that each data point in the series has a different color.
chart.Views[0].VaryColors = true;