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

Fix Incorrect Formatting Using Flash Fill In Excel  Flash Fill in Excel is a new feature that was introduced in Excel 2013.  One of the cool uses of Flash Fill is to fix incorrect formatting in your text automatically.Ever had the scenario where your data is formatted differently?Example: First names starting wit...
Thermometer Excel Chart Thermometer Charts are one of the many Charts you can create in Excel.  It does not really exist in Excel, however we can get creative and create our own.A Thermometer Chart gives you a good view of the percentage of progress made on your project, budget etc.We are going ...
Add High & Low Points in an Excel Sparkline Sparklines are a great way to visualize lots of data quickly.  Differentiating the High and Low points within the Sparkline pinpoints your strong and weak data points.To enter a High or Low marker you need to click inside your Sparkline which will activate the Sparkline Tools...
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...