When you create a chart, you can add axis titles to any horizontal, vertical, or depth axes in the chart. The titles will help the people who view the chart understand what the data is about. You can’t add axis titles to charts that don’t have axes (like pie or doughnut charts).
- Click anywhere in the chart to which you want to add axis titles.
- Click the Chart Elements button next to the upper-right corner of the chart.
- Check the Axis Titles box.
Primary horizontal and vertical axis titles are added to the chart.
- If your chart is a 3-D chart, or if it has secondary horizontal or vertical axes, click the arrow next to Axis Titles, and then click More Options to select the depth or secondary axis titles you want to add.
- Click each Axis Title box that appears in the chart, and then type the text that you want.
To start a new line in the title, press Shift+Enter.
- To format the axis titles, right-click them, and then click Format Axis Title to choose the formatting options you want.
Link axis titles to text on the worksheet
If you want to use text on the worksheet for your axis titles, you can link axis titles to the worksheet cells that contain that text. Linked titles are automatically updated in the chart when you change the corresponding text on the worksheet.
- On the chart, click an Axis Title box.
- On the worksheet, click inside the formula bar (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.), and then type an equal sign (=).
- Select the worksheet cell that contains the text that you want to use for the axis title.
- Press Enter.
In addition to changing the text of axis titles, you may want to change the axis labels. You can also add a chart title to your chart.