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.


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

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

  • Secondly, select the whole data and go to the Insert tab.
  • Thirdly, click on the Insert Pie or Doughnut Chart and select 2-D Column.

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 Edit Data Labels in Excel


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 needs.

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

Read More: How to Format Data Labels in Excel


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.

Download Practice Workbook

You can download the practice workbook from here.


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. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles


<< Go Back To Data Labels in ExcelExcel 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.
Zehad Rian Jim
Zehad Rian Jim

Zehad Rian Jim is a dedicated professional with a BSc. Degree in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. He's good with Microsoft Office and has written more than 80 helpful articles for ExcelDemy in the last year. Now, he makes fun and easy-to-follow Excel tutorials for YouTube as part of the ExcelDemy Video project. Zehad loves figuring out Excel problems, and his passion for learning new things in Excel shines through in... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo