We’re gonna move on now and try out some more tricks. In case you want to display the title of only one of the axes, click on this black arrow here, right next to the option Axis Titles, and you can choose which axis title will be displayed and which one won’t. If you select the option ‘Axis Titles’, both horizontal and vertical axis titles appear in the graph area. Then click on the green plus sign located on the right-hand side of the graph.

How to Display Vertical And Horizontal Axis Titlesįirst thing if you want to display the axis titles on a graph is to click anywhere within the graph area. And don't forget to subscribe to my free email newsletter below to stay updated with all these answers.Today, we’ll carry on improving this line graph and we’ll have a look at how to add axis titles in the graph area. Please leave a comment below with any questions. You will also be able to upload your file or screenshot to help explain your question. You can get your Excel or VBA question answered too! Click the link below to submit your question. This article is based on a question from Tony. Therefore, the plot area needs to be smaller than the chart area to fit the axis labels, and titles outside the chart. In the case of Tony's chart in the video, he was having trouble seeing the axis titles and labels because the plot area was too large. So if you select the outside border of the chart and resize it, the plot area will also resize proportionally. The plot area also resizes with the chart area. This makes it difficult to distinguish the difference between the two areas of the chart. Sometimes the plot area can fill up the entire chart area. The Chart Area and Plot Area Are the Same Size

If you can't read the titles or labels this tip will help cleanup your chart to make it more presentable. This post and video answers a question on how to resize the plot area of a chart to prevent the axis titles and labels from overlapping. Learn how to re-size the plot area of a chart to prevent the axis titles and labels from overlapping.

Excel graph axis label text