Tip:
Highlight text to annotate it
X
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.
Click the chart.
Click the Chart Layout tab.
Click Chart Title.
Click Title Above Chart.
Excel adds the title.
Type the title that you want to put.
Add the axis Titles.
Click Axis Titles.
Click Horizontal Axis Title.
Click Title Below Axis.
Excel adds the title.
Type the title.
Click Axis Title.
Click Vertical Axis Title.
Click Rotated Title.
Excel adds the title.
Type the title.
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,
Click the chart.
Click the Chart Layout tab.
Click Data Labels.
Click the position you want to use for the data labels.
Remember that the position options you see depend on the chart type.
Excel adds the labels to the chart.
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.
Click the chart.
Click the Chart Layout tab.
Click Data Table.
Click Data Table with Legend Keys.
If you prefer not to display the legend keys, click Data Table.