How to Add Title in Excel Graph (2 Quick Ways)

Title is a very important element in an Excel Graph. It tells us what the graph is about and makes the chart or graph more understandable to other persons. In Microsoft Excel, you can easily add a title to a graph. This article demonstrates how to add a title in Excel Graph with 2 handy methods.


Download Practice Workbook

You can download the practice workbook from the link below.


2 Ways to Add Title in Excel Graph

Let’s assume we have a dataset of Weekly Sales of two different models of Laptop and also their Weekly Comparison Chart. But, there is no title in this chart. So, you want to add a title to the Excel Graph. Now, we will see 2 easy ways to add a title to this graph.

Dataset

We have used Microsoft Excel 365 version for this article, you can use any other versions according to your convenience.


1. Utilizing Chart Elements Button

In this method, we will use the Chart Elements Button to add a title. This method is very fast and convenient. Now, to use this method follow the below steps.

Utilizing Chart Elements Button

Steps:

  • First, select the chart.
  • Then, click on the Chart Elements button, which looks like a green plus sign.
  • After that, select Chart Title.

Utilizing Chart Elements Button

  • Also, you can choose the position of the Chart Title.
  • In this case, we choose Above Chart.

Utilizing Chart Elements Button

  • Consequently, you will have an output as shown in the screenshot below.

Utilizing Chart Elements Button to Add Title in Excel Graph

Now, we will edit the Chart Title and also format it to change the text color.

  • At this point, click on the Chart Title.
  • Next, edit the text and change it to Weekly Sales Comparison (or whatever you want).

Utilizing Chart Elements Button to Add Title in Excel Graph

  • After that, double-click on the Chart Title.
  • Subsequently, on the right side of your screen, the Format Chart Title wizard will appear, and then go to the Text Options.
  • After that, go to Text Fill & Outline.
  • Next, select your preferred color from the Color options. In this case, we choose Green, 25% darker.

  • Finally, you will finish adding a title in Excel Graph and have an output as shown in the below screenshot.

Utilizing Chart Elements Button to Add Title in Excel Graph

Read More: How to Change to Title Case in Excel (4 Easy Ways)


Similar Readings


2. Using Chart Tools to Add Title in Excel Graph

In this method, we will use the Chart Tools from the top of the screen to add a title to Excel Graph. Now, to use this method follow the below steps.

Utilizing Chart Elements Button

Steps:

  • At the very beginning, select the chart.
  • Then, go to the Chart Design tab from the top of the screen.
  • After that, click the Add Chart Element group.
  • Then, select the Chart Title dropdown.
  • Next, click on the Above Chart option.

Using Chart Tools to Add Title in Excel Graph

At this point, edit the chart text and format it as shown in the above method.

  • Lastly, you will have an output as shown in the below screenshot.

Using Chart Tools to Add Title in Excel Graph

Read More: How to Make a Title Page in Excel (An Ultimate Guide)


How to Add Axis Title in Excel Graph

Suppose, you have an Excel Graph where the Axis Titles are missing. Therefore, you want to add Axis Title to the Graph. Now, to do so follow the below steps.

How to Add Axis Title in Excel Graph

Steps:

  • First, select the chart.
  • Next, click on the Chart Elements button.
  • After that, select Axis Titles.

How to Add Axis Title in Excel Graph

  • Now, edit the texts of the Axis Title (For the X-axis we have used Week, and for the Y-axis Sales Quantity as titles).
  • Finally, you will have an output as shown in the below screenshot.

How to Add Axis Title in Excel Graph


How to Remove Title from Excel Graph

Let’s assume you have a graph with a title. For enhancing the space of the chart area or for any other reason, you may want to remove the title from your Graph. Now, to do so follow the below steps.

How to Add Axis Title in Excel Graph

Steps:

  • At the very beginning, select the chart.
  • Next, click on the Chart Elements button.
  • Now, deselect Chart Title.

  • Eventually, you will finish removing your Chart Title.

How to Remove Title in Excel Graph


Practice Section

For doing practice by yourself we have provided a Practice section like below in each sheet on the right side. Please do it by yourself.

Practice Section


Conclusion

In this article, I showed you how to add a title in an Excel graph with different methods. Also, I showed you how to add axis titles in Excel Graph and how to remove any title in Excel Graph.
Last but not the least, I hope you found what you were looking for from this article. If you have any queries, please drop a comment below. Also, if you want to read more articles like this, you can visit our website ExcelDemy.


Related Articles

Sowmik Chowdhury

Sowmik Chowdhury

Hello! Welcome to my Profile. I , Sowmik Chowdhury, graduated from the Bangladesh University of Engineering and Technology from the Department of Naval Architecture and Marine Engineering. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this..

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo