Insert Titles, Labels and Tables in Excel Charts

Insert Titles, Labels and Tables in Excel Charts

 

 

Add Chart Titles:

You can make your chart easier to read and easier to understand by adding one or more titles to the chart. For example, you can add a chart title, which is a title that appears at the top of the chart and is usually a word or short phrase that describes the chart data.

You can also add titles to the chart axes. The primary horizontal axis title is a title that appears below the chart’s category (X) axis; the primary vertical axis title is a title that appears the left of the chart’s value (Y) axis.

Add Data Labels:

You can make your chart easier to read by adding data labels. A data label is a small text box that appears in or near a data marker and displays the value of that data point. Excel offers several position options for the data labels, and these options depend on the chart type. For example, with a column chart you can place the data labels within or above each column, and for a line chart you can place the labels to the left or right.

Display a Data Table:

You can make it easier for yourself and others to interpret your chart by adding a data table. A data table is a tabular grid where each row is a data series from the chart, each column is a chart category, and each cell is a chart data point. Excel gives you the option of displaying the data table with or without legend keys, which are markers that identify each series.