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.

 

 

 

Please wait...

Subscribe to ExcelMOOC posts

Want to be notified when our Excel article is published? Enter your email address and name below to know all new Excel features and cool tips