Create and format a pie chart in Excel

  1. Visualize your data by blowing up a piece of the pie
  2. Enter and select training data
  3. Create a simple pie chart
  4. Add a chart title
  5. Add data labels to a pie chart
  6. Change colors
  7. Explode a piece of a pie chart

Visualize your data by blowing up a piece of the pie

A pie chart is a visual representation of data and is used to show the sums of multiple categories relative to the total value of all categories. Pie charts are used, for example, to show a factory’s products in relation to a company’s products, or to show the sales of one product in relation to the sales of the entire product line.

The instructions in this article apply to Excel 2019, 2016, 2013, 2010; and Excel for Office 365.

Enter and select training data

Enter the chart data before creating a pie chart. Then select the data you want to use in the pie chart.

To follow this guide, enter the information in the image above on the blank sheet.

Create a simple pie chart

The basic pie chart is a simple, unformatted chart that displays standard data categories, a legend, and a chart title.

To create a pie chart, select the data in cells A3 to B6 and do the following:

  1. On the ribbon, go to the tab Insert .

  2. Select Insert Pie Chart to view the available pie chart types.

  3. Hover your mouse over a chart type to read the chart description and view the pie chart.

  4. Select a chart type. For example, choose 3D cake to add a 3D pie chart to the worksheet.

Add a chart title

Edit the default chart title to make it more appropriate.

  1. Select a default chart title. A frame appears around the title.

  2. Click on the text to put Excel in edit mode and place the cursor in the title field.

  3. Click remove or backspace to delete existing text.

  4. Enter a title for the chart. For example, enter The Biscuit Shop 2018 Sales Income .

  5. To split a heading into two lines, place the cursor between two words and press Enter . For example, place the cursor between 2018 and Income .

Add data labels to a pie chart

There are many different parts of a chart in Excel, such as the chart area, which contains a pie chart representing the selected data series, a legend, and a chart title and labels. All of these parts are separate objects and each can be formatted separately. Select it to tell Excel what part of the chart you want to format.

If you didn’t get the results you wanted, the right side of the chart is not selected. A common mistake is to select the plot area in the center of the field when you intend to select the entire field. The easiest way to select the entire chart is to select the corner of the chart.

If you make a mistake, use Excel’s undo function to correct the mistake. Then select the right side of the chart and try again.

To add data labels to a pie chart:

  1. Select the plot area of ​​the pie chart.

  2. Right click on the chart.

  3. Select Add data labels .

  4. Select Add data labels . In this example, the sales for each cookie are added to the slicers of the pie chart.

Change colors

When you create a chart in Excel or select an existing chart, two additional tabs are added to the ribbon. These Chart Tools Design and Format tabs contain formatting and layout options specific to charts.

To change the color of segments, background, or text:

  1. Select an area in the background of the chart to highlight the entire pie chart.

  2. To change the color of the pie chart fragments, go to the section Chart tool design and choose Change colors .

  3. Hover over the color bar to see the color in the pie chart.

  4. Pick a color. The pie slices change to different shades of the chosen color.

  5. To change the background color of the pie chart, go to the tab Chart Tools Format .

  6. Select fill form .

  7. Pick a color.

  8. To add a gradient to the background color, select fill form .

  9. Select course .

  10. Choose a gradient style.

  11. To change the text color of the header and data labels, select the drop-down arrow Fill with text .

  12. Pick a color.

Explode a piece of a pie chart

To emphasize part of the pie, drag or blow a piece out of the rest of the pie. After the slide is broken, the rest of the pie chart shrinks, keeping the chart area the same size.

Resizing the chart can move the data labels outside the pie slices. Drag the data label to move it to the slicer.

To blow up a piece of a pie chart:

  1. Select the plot area of ​​the pie chart.

  2. Choose a slice pie chart to surround the segment with small blue dots.

  3. Drag a piece of the pie chart to make it explode.

  4. To change the position of a data label, select the data label to select all data labels.

  5. Select the data label you want to move and drag it to the desired location.

Leave a Reply

Your email address will not be published.