How to Change Axis Titles in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

In our daily life, we deal with lots of graphs and charts. Sometimes we feel the necessity of changing the axis titles of the graphs and charts according to our needs. In this article, we will learn how to change axis titles in Excel with some easy steps. So, without any further delay, let’s get started.

In order to explain the step-by-step procedure, we will need an existing Excel chart with existing axis titles. We will then change the existing axis titles according to our needs in Excel. If you don’t have an existing chart, you have to create a chart and give the titles of the horizontal and vertical axis. After that, you can follow the following steps to change axis titles in Excel.


Step 1: Opening an Existing Excel File with a Chart

  • First of all, open an existing Excel file with a chart. It has existing axis titles on the chart.

Open Excel File with Chart


Step 2: Selecting Chart to Change Axis Titles

  • Secondly, left-click on the chart you want to change the axis titles.

Select Chart to Change Axis Titles

Read More: How to Add Axis Titles in Excel


Step 3: Changing Horizontal Axis Titles in Excel

  • At first, left-click on the existing horizontal axis title to change it.

Change the Horizontal Axis Titles

  • Then, remove the existing title by using the Backspace key like the picture below.

Change the Horizontal Axis Titles

  • Next, type your desired horizontal axis title in the title box like below.

Change the Horizontal Axis Title

  • After that, when you have finished typing your desired horizontal axis title, click on any empty cell of the worksheet.
  • As a result, you will see your desired horizontal axis title like the below image.


Step 4: Changing Vertical Axis Titles in Excel

  • At first, left-click on the existing vertical axis title to change it.

Change Vertical Axis Titles

  • Secondly, remove the existing title by using the Backspace key like the below image.

Change Vertical Axis Title

  • Next, type your desired vertical axis title in the title box like below.

Change Vertical Axis Title

  • After that, when you have finished typing your desired vertical axis title, click on any empty cell of the worksheet.
  • As a result, you will see your desired vertical axis title like the below image.


Final Output

  • Finally, you will see an output like the below diagram of your desired horizontal and vertical axis titles.

Final Output


Things to Remember

  • You need to have an existing chart with existing axis titles in order to follow this method.
  • You can also change the format of your titles after changing them in Excel.

Download Practice Workbook

You can download the Excel workbook from here.


Conclusion

Hence, follow the above-described steps. Thus, you can easily learn how to change axis titles in Excel. Hope this will be helpful. Don’t forget to drop your comments, suggestions, or queries in the comment section below.


Related Articles


<< Go Back To Label Axis in Excel | Excel Chart Elements | Excel Charts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Asaduzzaman
Md. Asaduzzaman

Hello! I am Md. Asaduzzaman. Currently, I am working as an Excel and VBA Content Developer and I will be posting my articles related to this here. I graduated from Bangladesh University of Science and Technology(BUET) in 2022. I completed my BSc in Naval Architecture and Marine Engineering. I like to solve real-life problems in Microsoft Excel and share the solutions through articles. I post here regularly. Hope you find the articles helpful.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo