This is the print version of this page. All content is copyright Indezine.com 2000-2017.



Data Labels in PowerPoint Charts

Learn about the Data Labels in PowerPoint charts.


Product/Version: All PowerPoint Versions
OS: NA






Data labels are indications used to quickly identify data series in a chart. In Figure 1, below you can see data labels displayed on top of the columns in a chart.
Data labels identify values for columns in a chart
Figure 1: Data labels identify values for columns in a chart

Guidelines for Using Data Labels

There are some essential guidelines that relate to data labels:

  1. Data labels are determined from the values you input on the worksheet for the chart. Once you update those values, they get updated automatically on the chart too.
  2. You can adjust the positions of the data labels to make them easier to read in the chart. You can also change the font and font size.
  3. Data labels are not compulsory. If you don't want to display data labels, you can remove them.
  4. Data labels often duplicate information available on the Vertical (Value) axis. It is therefore acceptable to get rid of the Vertical axis if you choose to show data labels, as shown in Figure 2, below (compare with Figure 1).

    Chart with data labels, and no Vertical axis
    Figure 2: Chart with data labels, and no Vertical axis

Data Label Tips and Ideas

Here are some ideas on using data labels more effectively:

  1. Do you want something other than the value to show in the data label? You can add series or category names, the legend color (key), or even all of them! You can also override all these options, and choose a particular cell value for any individual data label.
  2. You have several options in positioning data labels, depending upon the chart type you are working. If any of the existing positioning options do not work for you, then manual positioning of data labels is also an option.
  3. You can change the font attributes of your data labels by altering font size, color, etc. You may be tempted to change the font itself, but only do so if you have a compelling reason to change the defaults, or if you are changing the font everywhere in the presentation or the chart.
  4. Data labels can be formatted as numbers, currency, dates, time, and many other field types. Each of these types offer separate formatting options.
  5. You can place data labels in a shape. Most of the time, this is not needed unless your data labels need to stand out.
  6. If you have a congested chart, or if you need to place your data labels at a distance, you may want to explore leader lines.

So as you see, data labels are an important chart element. Used effectively, data labels can help you illustrate a concept better to your audiences.

PowerPoint Keyboard Shortcuts and Sequences:
PowerPoint 2016, 2013, 2011, 2010, 2007 and 2003 for Windows
PowerPoint 2016 and 2011 for Mac
PowerPoint Online for Windows and Mac

Have your ever used keyboard shortcuts and sequences in PowerPoint? Or are you a complete keyboard aficionado? Do you want to learn about some new shortcuts? Or do you want to know if your favorite keyboard shortcuts are documented?

Go and get a copy of our PowerPoint Keyboard Shortcuts and Sequences ebook.



Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

Home | PowerPoint | Photoshop | PowerPoint Templates | PowerPoint Tutorials | Blog | Notes | Ezine | Advertise | Feedback | Site Map | About Us | Contact Us

Link to Us | Privacy | Testimonials

PowerPoint Backgrounds | Christian PowerPoint Backgrounds | Business PowerPoint Presentation Templates

Plagiarism will be detected by Copyscape

©2000-2017, Geetesh Bajaj. All rights reserved.

since November 02, 2000