Just remember to save your workbook so you can come back to it later. Once you’ve made the changes you want, your pie chart is ready to go. For example, you can change the color of the slices, add data labels, and more. To do this, click on the chart and then click on the Format tab.įrom there, you can make a number of different changes to the appearance of your pie chart. The next step is to format your pie chart to make it look its best. Once you click on the option you want, a pie chart will appear on your worksheet. For this example, we’ll choose the first option. You’ll then see a variety of different pie chart options. Once your data is selected, click on the Insert tab and then click on the Pie chart icon. To select the data, click on the cell in the upper-left corner of the data and drag your mouse down and to the right to highlight all of the cells you want to include. For this example, we’ll use data on the percentage of people in different age groups who use different social media platforms. The first step is to select the data that you want to include in your pie chart. But with a few simple tips, you can create a pie chart that looks great and conveys the information you need to communicate effectively. Sharing and Presenting Pie Charts in Excelįew things are more frustrating than trying to create a pie chart in Excel, only to have it come out looking like a mess.Analyzing and Interpreting Data from a Pie Chart.

Formatting and Fine-tuning the Pie Chart.

Adding Data Labels and Exploding Pie Slices.

Customizing the Appearance of the Pie Chart.

Gathering and Organizing Data for a Pie Chart.Understanding the Purpose and Benefits of Pie Charts in Excel.

Create percentage pie chart excel