Best Excel Graph Axis Title
Alternatively choose Format Selected Axis Title from the main menu.
Excel graph axis title. Also horizontal axis labels in the chart above Qtr 1 Qtr 2 Qtr 3 and Qtr 4 are different from the legend labels below them East Asia Sales 2009 and East Asia Sales 2010. Adding an Axis Title To add an Axis label at the top of your chart if you have Excel 2007 or Excel 2010 click the Layoutmenu at the top of Excel. If you want to display the title only for one axis either horizontal or vertical click the arrow next to Axis Titles and clear one of the boxes.
The end result is you eliminate the labels overlapping the chart and it is easier to understand what you are seeing. To change the titles text later edit the text in the linked cell rather than on the chart. The e was half displayed leaving an impression of cracking words.
See below screen shot. To link an axis title to an existing cell select the title click in the formula bar type an and then click the cell. Click an axis title and begin typing to write a label by hand.
This article is based on a question from Tony. Click on the plus sign you will see the list of the Chart Elements such as Axis Axis Titles. Click on the axis label to select the label.
When you first create a chart in Excel normally there is no Axis title in the chart. There is a really quick fix for this. To learn how to add them see Add or remove titles in a chart.
If you would only like to add a titlelabel for one axis horizontal or vertical click the right arrow beside Axis Titles and select which axis you would like to add a titlelabel. Group two-level axis labels with Pivot Chart in Excel. Click on the chart and you will see 3 icons appear on the right of the chart.