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”


Data Labels2



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


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

100% Stacked Bar Chart A 100% Stacked Bar Chart is a great way to compare a percentage that each value contributes to its total.So if we have sales rep sales for three consecutive years, we can plot this on a graph and it will show us what each sales rep´s percentage breakdown is per year.DOWNL...
Create a Sunburst Chart With Excel 2016 Sunburst Charts are one of the many new Charts available only in Excel 2016.They are very visual as it can easily show you hierarchical data, like having a table with different levels of categorization:Each hierarchy is drawn by one ring in the sunburst chart. The inn...
Custom Chart Labels Using Excel 2013 In a previous blog post we created a Benchmark Chart using Excel 2013.  We are going to extend this concept and add some cool looking custom chart labels to make our chart more informative.View the Benchmark Chart using Excel 2013 DOWNLOAD EXCEL WORKBOOKSTEP ...
Add an Interactive Vertical Column in Your Excel L... With Excel Charts, it is very easy to create a Vertical Column in your Line Chart and make it interactive with a Scroll Bar!The reason why I do this, is to use the vertical column to highlight a specific point in my Excel chart whilst I am presenting the data to my stakeholde...