Data Labels make an Excel chart easier to understand because they show details about a data series or its individual data points.

Depending on what you want to highlight on a chart, you can add labels to one series, all the series (the whole chart), or one data point.

In our example below, I add a Data Label to a column chart and then I format the data label using CTRL+1.

I then select to custom format the numbers so it shows the values as thousands by adding a comma , after each zero and then showing the work k by adding “k”

Example Custom Number Format:    [$$-1004]#,##0,”k”;-[$$-1004]#,##0,”k”

DOWNLOAD WORKBOOK

Data Labels2

HELPFUL RESOURCE:

728x90

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin