Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Use Millions in Data Labels of Excel Chart (3 Easy Ways)

If you want to create chart data labels in Millions in Excel, you have come to the right place. Here, we will walk you through 3 easy methods to do the task effortlessly.


Download Practice Workbook

You can download the Excel file and practice while you are reading this article.


3 Methods to Use Millions in Data Labels of Excel Chart

In the following dataset, you can see the Month and Sales columns. After that, using this dataset, we will insert a Column chart.

Data Table for Excel Chart Data Labels in Millions

  • First of all, we will select the entire dataset by selecting cells B4:C11.
  • After that, we will go to the Insert tab.
  • Then, from the Insert Column or Bar Chart group >> we will select a 2D Column chart.

As a result, you can see the Column chart.

Here, in the Column chart, you can easily notice that the values in the Y axis are in General number format. Then, in the following article, we will go through 3 easy and effective methods to create chart data labels in Millions in Excel.

Here, we used Microsoft Excel 365. You can use any available Excel version.

Creating Column Chart for Excel Chart Data Labels in Millions


1. Using Custom Number Format to Use Millions in Data Labels

In this method, we will use the Custom Number format to create Excel Chart Data Labels in Millions. Here, we will format the data of the data table in millions, and therefore, the chart data will also be formatted to millions.

This method is helpful when we want to format both the data table and the chart.

Steps:

  • First of all, we insert a Column chart by following the Steps described earlier.

As a result, you can see the Column chart.

  • After that, to format the Sales column of the data table in millions, we will select cells C5:C11.
  • Afterward, from the Home tab >> we will click on the Number Format icon which is marked with a red color box.
  • Moreover, we will click on More Number Formats.

At this point, a Format Cells dialog box will appear.

  • Then, we will select Custom from the Category.
  • Moreover, we will type #,, “Million” in the Type box.

This will format cells C5:C11 in Millions.

  • Furthermore, click OK

Using Custom Number Format for Excel Chart Data Labels in Millions

Therefore, you can see the Sales column in Million.

Along with that, the Y axis of the chart now shows value in Millions.

Custom Number Format to Make Excel Chart Data Labels in Millions

After that, we will Format the chart to make the chart more presentable and eye soothing.

  • To do so, we will click on the Chart >> go to the Chart Design tab.
  • Then, from various Chart Designs, we select a design according to our choices.

Hence, you can see the chart data labels in millions.

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


2. Use of Format Axis Feature of Excel Chart to Create Data Labels in Millions

In this method, we will use the Format Axis feature to create Excel chart data labels in millions.

Steps:

  • In the beginning, we insert a Column chart by following the Steps described earlier.

Therefore, you can see the Column chart.

Use of Fomrat Axis Feature to Create Excel Chart Data Labels in Millions

  • Afterward, we will right-click on the Y-axis of the chart.
  • Then, we will select Format Axis from the Context Menu.

At this point, a Format Axis dialog box will appear at the right end of the Excel sheet.

  • Then, we will click on Number >> click on the drop-down icon of the Category box.

  • After that, we will select Custom.

Applying Custom Category to Create Excel Chart Data Labels in Millions

  • Then, we will type the format [>999999] #,,”M” in the Format Code box.
  • In addition, click on Add.

As a result, you can see the data labels in million in the chart.

  • Furthermore, we will format the chart by following the Steps described in Method-1.

Hence, you can see the Excel chart data labels in million.

Formatting Chart to Make Excel Chart Data Labels in Millions

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


Similar Readings


3. Applying Format Data Labels Feature

In this method, we will add data labels to our chart, and then, we will use the Format Data Labels feature to create Excel chart data labels in millions.

Steps:

  • First of all, we insert a Column chart by following the Steps described earlier.

As a result, you can see the Column chart.

  • After that, we will click on the Chart Elements >> click on Data Labels.

Adding Data Labels to Create Excel Chart Data Labels in Millions

Therefore, you can see the Data Labels in the chart.

  • Afterward, we will right-click on Data Labels >> select Format Data Labels from the Context Menu.

Using Format Data Labels to Craete Excel Chart Data Labels in Millions

Afterward, a Format Data Labels dialog box will appear at the right end of the Excel sheet.

  • Then, we will click on Number >> click on the drop-down icon of the Category box.
  • Along with that, we will select Custom.

  • Later, we will type #,, “Million” in the Format Code box.
  • Then, click on Add.

Hence, you can see the chart data labels in millions.

  • Furthermore, we will format the chart by following the Steps described in Method-1.

Therefore, you can see the Excel chart data labels in million.

Read More: How to Add Data Labels in Excel (2 Handy Ways)


How to Use Thousands in Data Labels of Excel Chart

Here, we will describe how you can create Excel chart data labels in Thousands.

Steps:

  • First of all, we insert a Column chart by following the Steps described earlier.

As a result, you can see the Column chart.

  • Afterward, we will right-click on the Y-axis of the chart.
  • Then, we will select Format Axis from the Context Menu.

At this point, a Format Axis dialog box will appear at the right end of the Excel sheet.

  • Then, we will click on Number >> click on the drop-down icon of the Category box.
  • Along with that, we will select Custom.

  • Later, we will type [>999999]  #,,”M”;#,”K” in the Format Code box.
  • Then, click on Add.

Therefore, you can see Excel chart data labels in Thousands.

  • Furthermore, we will format the chart by following the Steps described in Method-1.

Hence, you can see the Excel chart data labels in thousands.

Read More: How to Add Two Data Labels in Excel Chart (with Easy Steps)


Practice Section

You can download the above Excel file to practice the explained method.


Conclusion

Here, we tried to show you 3 easy methods for Excel chart data labels in millions. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section below. Please visit our website Exceldemy to explore more.


Related Articles

Afia

Afia

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo