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.
- 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.
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: 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.
- 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 (with Easy Steps)
Similar Readings
- How to Change Font Size of Data Labels in Excel
- Edit Data Labels in Excel (6 Easy Ways)
- How to Show Coordinates in Excel Graph (2 Easy Methods)
- Add Outside End Data Labels in Excel (2 Examples)
- How to Change Data Labels in Excel (with Easy Steps)
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 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
- How to Remove Zero Data Labels in Excel Graph (3 Easy Ways)
- How to Show Data Labels in Excel 3D Maps (2 Easy Ways)
- Data Labels in Excel Pivot Chart (Detailed Analysis)
- How to Move Data Labels In Excel Chart (2 Easy Methods)
- How to Rotate Data Labels in Excel (2 Simple Methods)
- [Fixed:] Excel Chart Is Not Showing All Data Labels (2 Solutions)