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.
How to Use Millions in Data Labels of Excel Chart: 3 Methods
In the following dataset, you can see the Month and Sales columns. After that, using this dataset, we will insert a column chart.
- 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.
Read More: How to Add Data Labels in Excel
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
Therefore, you can see the Sales column in Million.
Along with that, the Y axis of the chart now shows value 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: How to Edit Data Labels in Excel
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.
- 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.
- 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.
Read More: How to Format Data Labels in Excel
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.
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.
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 Change Font Size of Data Labels in Excel
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 Show Data Labels in Thousands in Excel Chart
Practice Section
You can download the above Excel file to practice the explained method.
Download Practice Workbook
You can download the Excel file and practice while you are reading this article.
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.