How to Change Font Size of Data Labels in Excel

Get FREE Advanced Excel Exercises with Solutions!

This tutorial will demonstrate the steps to change the font size of data labels in excel. Font size is very important to present a graph with a proper description. It can be also very useful in emphasizing particular points. Just making text larger or smaller can have a huge impact on the reader or viewer. So, well follow the below methods to know how to change the font size of data labels.


Download Practice Workbook

You can download the practice workbook from here.


2 Practical Examples to Change Font Size of Data Labels in Excel

We’ll use a simple dataset to illustrate 2 examples to understand this article easily. If you follow the examples with proper steps then you should learn how to change the font size of data labels in excel on your own. The examples are given below with descriptive steps.


1. Change Font Size of Data Labels in Excel for 2-D Column Chart

Our main goal is to change the font size of data labels in Excel to make the graph or data more visually attractive and understandable. In this case, we are describing the steps to change the font size for a 2-D Column chart:

Steps:

  • Firstly, we have a dataset of people with their Working Hours in Column C and Daily Pay in Column D. At this point, we want to change the font size of the data labels.

Change Font Size of Data Labels in Excel for 2-D Column Chart

Change Font Size of Data Labels in Excel for 2-D Column Chart

  • Fourthly, select the whole graph and click on the Chart Elements option and go to the Data Labels.

Change Font Size of Data Labels in Excel for 2-D Column Chart

  • After that, you will get the result like the below image.

  • Next, select the data chart and go to the Home tab.
  • Then, choose the font size accordingly.

Change Font Size of Data Labels in Excel for 2-D Column Chart

  • Finally, the following result will come up on your screen.

Read More: How to Format Data Labels in Excel (with Easy Steps)


2. Modify Font Size of Data Labels for Pie Chart

We are using the same dataset as the first example with a slight change. In this case, we will gonna modify the font size of the data labels for the Pie Chart. Let’s describe the steps below in order:

Steps:

  • Initially, select the whole data and go to the Insert tab.
  • After that, click on the 2-D Pie.

Modify Font Size of Data Labels for Pie Chart

  • After getting the proper pie chart, select the whole chart and choose Data Labels from the Chart Elements.

  • Then, select the data and go to the Home tab.
  • Afterward, choose the proper font size according to your need.

  • In the end, the following result will come up on the screen.

Read More: What Are Data Labels in Excel (Uses & Modifications)


Things to Remember

  • We have shown the steps of changing the font size of data labels of the 2-D Column Chart and 2-D Pie Chart in two examples. But it is recommended to never use the 3-D Pie or 3-D Column Chart option because it’s simply of no use. In many cases, it creates confusion by carrying the wrong message.
  • You should change the font in a way so that it is easily understandable. It is recommended to have enough space between the fonts otherwise it seems a little messy and difficult to understand.

Conclusion

Henceforth, follow the above-described methods. Thus, you can change the font size of data labels in excel. Let us know if you have more ways to do the task. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Zehad Rian Jim

Zehad Rian Jim

Hi there! I am Zehad Rian Jim. I graduated with a bachelor's degree in engineering from BUET. Currently, I am working as a technical content writer at ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include watching movies, tv series, and meeting new people. I also enjoy sports. My favorite sports are Cricket (to watch and play) and Badminton (play).

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo