Indezine Logo




Label Options for Chart Data Labels in PowerPoint 2013 for Windows

Explore options to edit content, position, and format of data labels in PowerPoint 2013 for Windows. These options can make your chart data more explanatory.


Author:

Product/Version: PowerPoint 2013 for Windows

OS: Microsoft Windows 7 and higher



Learn PowerPoint

Explore Timelines that are Different – 05.



The data labels that you add to your PowerPoint charts can be enhanced by exploring Format Data Label options. These Format Data Label options include Label Options to edit the content, the position, and the format of data labels, as explained in this tutorial.

To begin, you need to have a chart on your slide. If you don't have one, insert a chart on your slide. Thereafter, enable data labels for your chart.

Then, follow these steps to format data labels in PowerPoint 2013 for Windows:

  1. Bring up the Format Data Labels Task Pane as explained in Step 1 within our Format Data Label Options for Charts in PowerPoint 2013 for Windows tutorial. Thereafter proceed with these further steps.
  2. In this Task Pane, make sure that the Label Options tab, as shown highlighted in red within Figure 1, below is selected. Then, click the Label Options button, as shown highlighted in blue within Figure 1.
  3. Label Options within Format Data Labels Task Pane
    Figure 1: Label Options within Format Data Labels Task Pane
  4. As you can see in Figure 1 above, Label Options have been divided into two categories: Label Options and Number. Let us start with exploring options within the Label Options section:
  5. Label Contains

  6. Includes check-boxes that decide the content of data labels. These are:
  7. Value From Cells

  8. This option is useful when you have stored labels or values you want to show as part of the data label, in an Excel sheet within a set of adjacent cells. This check-box may not be available if you have selected only one data label. To use this option, first make sure you keep the Excel sheet containing the data labels open before you select this check-box. Selecting this check-box launches an instance of Excel sheet, along with Data Label Range dialog box as shown highlighted in red within Figure 2, below.
  9. Data Label Range dialog box
    Figure 2: Data Label Range dialog box
  10. Within the instance of the open Excel sheet, select the set of adjacent cells that contain text or digits that you want to show as part of the data label. Take a look at the instance of Excel sheet in our sample chart within Figure 2, above, where we have selected cells containing alphabets A to E. The selection is also reflected within the Data Label Range dialog box. Click the OK button when you are done to see the result within the chart's data labels, as shown in Figure 3, below.
  11. Alphabets taken from Excel cells added as part of the Data Label
    Figure 3: Alphabets taken from Excel cells added as part of the data label
  12. Series Name

  13. Displays name of the series in data labels.
  14. Category Name

  15. Displays name of the category in data labels.
  16. Value

  17. Displays data values of series in data labels.
  18. Show Leader Lines

  19. Select to show the leader lines. A leader Line is a line that points to a data label to its associated data point (or, column in a column chart). This option is helpful when you’ve placed a data label away from a data point (or column).
  20. Leader Line
    Figure 4: Leader Line
  21. Legend key

  22. Select this check-box if you want to show the legend key (the color block shown in chart legends) in front of the data label. Figure 4, above shows the legend key in front of the data label.
  23. Label Position

  24. Includes four radio buttons that decide the position of data labels. These options have already been explained in our Chart Data Labels in PowerPoint 2013 tutorial.
  25. Now, let's explore options within the Number section:
  26. Category

  27. Clicking this option opens a drop-down menu as shown in Figure 5, below. Click on the required format option for the data labels to select it.
  28. Category drop-down list
    Figure 5: Category drop-down list
  29. Format Code

  30. This option is helpful when you want your data labels to be easily-readable. This is done by changing longer digits to show fewer digits. To do so, first you need to select the Custom option within the Category drop-down list. Then, within the Format Code box, type the required format of the data label numbers to be displayed. Thereafter, click the Add button,highlighted in green within Figure 1, as shown previously on this page, to apply the new format.
  31. Use any of the Label Options to format your data labels as required.
  32. Save your presentation often.

Chart Data Labels: Label Options for Chart Data Labels (Glossary Page)

You May Also Like: The Importance of Screen Calibration | Forest Fire PowerPoint Templates


Popular Posts

Playing Video Across Slides in PowerPoint 2016 for Windows
Playing Video Across Slides in PowerPoint 2016 for Windows
Play a video clip across slides in PowerPoint 2016 for Windows.

Set Document Resolution in PowerPoint 2016 for Windows
Set Document Resolution in PowerPoint 2016 for Windows
Learn how to set document resolution in PowerPoint 2016 for Windows.

Creating Anchor Points for Connectors in PowerPoint 2010 for Windows
Creating Anchor Points for Connectors in PowerPoint 2010 for Windows
Learn how to create Anchor Points for connectors in PowerPoint 2010.

Working With Slide Numbers in PowerPoint 2016 for Windows
Working With Slide Numbers in PowerPoint 2016 for Windows
Learn how to add Slide Numbers on slides and Masters and more tricks on making them work to your will in PowerPoint 2016 for Windows.



Gears for PowerPoint (Series 01)

All these gears are native PowerPoint shapes. You can recolor them, add effects, and do more, all inside PowerPoint. Results which would have taken hours to achieve now take less than a minute! Have fun using the gear graphics, and make your audience take notice! All these gears can be rotated and resized, as required. Since they are essentially pictures, all types of edits that you can do with pictures work with them too!

Get this complete kit now, you’ll save so much time that you can use doing something else!

This is the original page. An AMP (Accelerated Mobile Page) version of this page is also available for those on mobile platforms, at Label Options for Chart Data Labels in PowerPoint 2013 for Windows.


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-2021, Geetesh Bajaj. All rights reserved.