Indezine Logo

  This is the print version of this page. All content is copyright 2000-2020.

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 for Windows.


Product/Version: PowerPoint 2013 for Windows

OS: Microsoft Windows 7 and higher

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:

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

    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.

    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:


    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

    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.

Organic Shapes with Brush Edges

You get 8 shape types plus lines as part of this Organic Shapes collection. Each of these 8 shape types have 10 variants. So you end up with 80 hand-drawn shape options! Again each of these 80 shapes have 12 brush stroke styles! Plus you get the lines and arrows in 12 brush stroke styles too. Combine all variations to end up with more than 3000 possibilities.

Buy and Download for $99+ (83 MB)

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