How to Show Data Labels in Thousands in an Excel Chart – 4 Steps

How to Edit Data Labels in Excel

You can edit data labels and customize them in Excel.

Select the data labels and go to format data labels.

• Choose Fill in Fill & Line.

• Select Solid fill and choose a Color.

Data labels are edited.

How to Show Data Labels in Thousands in Excel Chart: 4 Steps

This is the sample dataset.

To create a chart and show the data labels in thousands:

Step 1: Create a Chart

• Select the range to create the chart.
• Go to the Insert tab >> Insert Column or Bar chart >> select Clustered Column.

This is the output.

Step 2: Add Data Labels

• To show the data labels, click the chart
• Select Chart Elements and check Data Labels.

This is the output.

Read More: How to Add Data Labels in Excel

Step 3: Format Data Labels

• Right-click any data label and select Format Data Labels.

Step 4: Use the Custom Code in the Label Options

• In the Format Data Labels window, in Label Options, select Number.

• In Category, select Custom.
• Add the following as Format Code. It will  automatically be placed in Type.

This is the output.

How to Show Numbers in Thousands in an Excel Chart

Your dataset can have thousands of rows.

Steps:

• Right-click any cell and select Format Cells.

Note: You can also press CTRL + 1.

• In the Format Cells dialog box, choose Custom in Category.
• In Type, enter:

• Click OK.

Values are displayed in thousands.

Select the data and plot a chart.

Read More: How to Use Millions in Data Labels of Excel Chart

Practice Section

Practice here.

Download Practice Workbook

Download the practice workbook.

Related Articles

• How to Show Data Labels in Excel 3D Maps
• How to Use Conditional Formatting in Data Labels in Excel
• How to Add Additional Data Labels to Excel Chart
• [Fixed!] Excel Chart Data Labels Overlap
• How to Add Outside End Data Labels in Excel

<< Go Back To Data Labels in Excel | Excel Chart Elements | Excel Charts | Learn Excel