How to Label a Pie Chart in Excel

Written by cayt landis
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Label a Pie Chart in Excel
You can use labels to display data points, series names and category names on an Excel pie chart. (pie chart 201 image by chrisharvey from Fotolia.com)

Microsoft Excel is one of the best software options for creating graphs. Excel offers many different features that make creating any graph easy, be it a pie chart, a flow graph or a bar graph. A quick way to make an useful graph with Microsoft Excel is to enter all of the data and present it in the form of a pie chart. It is important to know how to label a pie chart in Microsoft Excel to get the most out of the graphing features.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Open Microsoft Excel and either create a pie chart or open an existing pie chart file. Be sure to have all of the necessary information plugged into the chart before you begin labelling.

  2. 2

    Click on the chart area to select the chart. The chart area is the chart itself and all of its specific elements.

  3. 3

    Add a label to all of the data points in the data series by clicking once on the data series. This will select the data series as a whole.

  4. 4

    Add a label to one specific data point by clicking the data series. Click again on the data point that you want to label to select it.

  5. 5

    Clicking on the data series or a specific data point will open the "Chart Tools" tab. Locate the "Labels" group and click on the "Layout" tab. Click the "Data Labels" icon and choose a display option. This will automatically label the data points that you previously selected.

  6. 6

    Create a custom label by clicking on the data label that you created. Click inside of the data label to enter edit mode. Highlight the existing label and retype custom text. This will replace the existing label.

Tips and warnings

  • You can customise your pie chart label in many different ways including the size, location, colour and font.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.