Home | Products | PowerPoint | PowerPoint Tutorials | Charts

Label Options for Chart Data Labels in PowerPoint 2013 for Windows

Learn about the Label Options that are used to edit content, position, and format of the Data Labels in PowerPoint 2013.

Article Ratings:

Author:

Product/Version: Microsoft PowerPoint 2013
OS: Windows 7 and 8







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 start with, 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. And then follow these steps to format Data Labels in PowerPoint 2013:

  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 (highlighted in red within Figure 1) is selected. Then, click the Label Options button, shown highlighted in blue within Figure 1.

    Label Options within Format Data Labels Task Pane
    Figure 1: Label Options within Format Data Labels Task Pane

    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 the options within the Label Options section:

    1. Label Contains: Includes check-boxes that decide the content of Data Labels. These are:

      Value From Cells: This option is useful when you have stored the labels or values which you want to show as part of the Data Label, in an Excel sheet within a set of adjacent cell. 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.

      Data Label Range dialog box
      Figure 2:
      Data Label Range dialog box

      Within the instance of the open Excel sheet, select the set of adjacent cells that contain the text or digits which you want to show as part of the Data Label. Take a look at the instance of Excel sheet in our sample chart 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 Data Labels, as shown in Figure 3.

      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

      Series Name: Displays name of the Series in the Data Labels.

      Category Name: Displays name of the Category in the Data Labels.

      Value: Displays Data values of Series in the Data Labels.

      Show Leader Lines: Select to show the Leader Lines. Leader Line is a line that connects 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).
      Leader Line
      Figure 4: Leader Line

      Legend key: Select this check-box if you want to show the legend key (the color block shown in the Legends) in front of the Data Label. Figure 4 above shows the legend key in front of the Data Label.

    2. Label Position: 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.

    Now, let's explore the options within the Number section:

    1. Category: Clicking this option opens a drop-down menu as shown in Figure 5 -- click on the required format option for the Data Labels to select it.

      Category drop-down list
      Figure 5: Category drop-down list

    2. Format Code: This option is helpful when you want to make the Data Labels with long digits to be easily readable by making them show fewer digits. To do that, 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, shown earlier on this page) to apply the new format.

  3. Use any of the Label Options to format your Data Labels as required.

  4. Save your presentation often.

 

PowerPoint Keyboard Shortcuts PowerPoint Keyboard Shortcuts and Sequences:
PowerPoint 2013, 2011, 2010, 2007 and 2003

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 E-Book.

PowerPoint Keyboard Shortcuts and Sequences E-book

 



comments powered by Disqus




Subscribe to Indezine
Follow Indezine

Follow Indezine on Pinterest
Share This Page
Bookmark and Share
Translate Page


Like This Page
Like This Site



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

since November 02, 2000