generate a progress pie chart in excel for mac

Hover over a row of colors to preview the color in the pie chart.

Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs.

A pie chart is a visual representation of data and is used to display the amounts of several categories relative to the total value of all categories.

Pie charts are used, for example, to show the production of one factory in relation to the output of the company or to show the revenue generated by one product relative to the sales of the entire product line.

To follow along with this tutorial, enter the data shown in the image above into a blank worksheet.

The basic pie chart is a plain, unformatted chart that displays the categories of data, a legend, and a default chart title.

To create a pie chart, highlight the data in cells A3 to B6 and follow these directions.

Select Insert Pie Chart to display the available pie chart types.

Hover over a chart type to read a description of the chart and to preview the pie chart.

Choose a chart type.

For example, choose 3-D Pie to add a three-dimensional pie chart to the worksheet.

Click on the text to put Excel in edit mode and place the cursor inside the title box.

Type a chart title.

For example, type The Cookie Shop 2018 Revenue from Sales.

To separate the title into two lines, place the cursor between two words and press Enter.

There are many different parts to a chart in Excel, such as the plot area that contains the pie chart representing the selected data series, the legend, and the chart title and labels.

All these parts are separate objects, and each can be formatted separately.

To tell Excel which part of the chart you want to format, select it.

If you dont get the desired results, the right part of the chart was not selected.

The easiest way to select the entire chart is to select a corner of the chart.

If you make a mistake, use the Excel undo feature to remove the mistake.

In this example, the sales for each cookie is added to the slices of the pie chart.

When a chart is created in Excel, or whenever an existing chart is selected, two additional tabs are added to the ribbon.

These Chart Tools tabs, Design and Format, contain formatting and layout options specifically for charts.

To change the color of the pie chart slices, go to Chart Tools Design and select Change Colors.

Generate A Progress Pie Chart In Excel For Mac