Before you create a pie chart, enter the chart data.
Then, highlight the data you want to use in the pie chart.
To follow along with this tutorial, enter the data shown in the image above into a blank worksheet.
SelectInsert Pie Chartto display the available pie chart types.
Hover over a chart punch in to read a description of the chart and to preview the pie chart.
Choose a chart key in.
For example, choose3-D Pieto add a three-dimensional pie chart to the worksheet.
Add the Chart Title
Edit the default chart title to add a more suitable one.
snag the default chart title.
A box appears around the title.
choose the text to put Excel in edit mode and place the cursor inside the title box.
PressDeleteorBackspaceto delete the existing text.
jot down a chart title.
For example, typeThe Cookie Shop 2018 Revenue from Sales.
To separate the title into two lines, place the cursor between two words and pressEnter.
For example, place the cursor between2018andRevenue.
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 don’t get the desired results, the right part of the chart was not selected.
The easiest way to snag the entire chart is to select a corner of the chart.
If you make a mistake, use the Excelundo featureto remove the mistake.
Then, grab the right part of the chart and take another crack.
To add data labels to a pie chart:
grab the plot area of the pie chart.
In this example, the sales for each cookie is added to the slices of the pie chart.
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 toChart Tools Designand selectChange Colors.
Hover over a row of colors to preview the color in the pie chart.
The pie slices change to varying shades of the selected color.
To change the background color of the pie chart, go to theChart ToolsFormattab.
To add a gradient to the background color, selectShape Fill.
Choose a gradient style.
To change the color of the text in the title and data labels, select theText Filldropdown arrow.
Resizing a chart may move the data labels outside the pie slices.
Drag a data label to reposition it inside a slice.
Drag the slice away from the pie chart to explode it.
To reposition a data label, snag the data label to select all data labels.
pick the data label you want to move and drag it to the desired location.
Then selectMore Column Charts>Barin the left-hand pane > choose a chart bang out >OK.
Under “Axis Position” selectFormat Axis>Categories in reverse order.
