In such graphs, the entire pie represents 100% of the whole, while the pie slices represent portions of the whole. Pie charts, or circular graphs as they are also known, are a popular way to show how much individual amounts or percentages contribute to the total. Select an element (dataset) you want to customize and click Shape Fill to change the fill color, Shape Outline to change the outline color and Shape Effects to add a certain style (such as 3D).In this Excel pie chart tutorial, you will learn how to make a pie chart in Excel, add or remove the legend, label your pie graph, show percentages, explode or rotate a pie chart, and much more. If you want to change the colors and styles of individual elements, you can go to the Format tab. Here, you will find several tools to customize your pie chart.

To change the legend location and data label, you can click the plus icon on the popup.Īlternatively, you can also go to the Design tab to customize your pie chart. You can also change the default color by going to the Color tab on the popup. There are 12 different styles offered by Excel. To do so, click your pie chart followed by Chart Styles. If you don’t like the default look of your pie chart, you can change its style.

How to customize your pie chartĮveryone never gets satisfied with something default. Once the data is highlighted, go to the Insert tab and click Insert Pie or Doughnut Chart on the Charts group and select a chart style.Ī pie chart will appear once you click a chart style. To turn the data like the one above into a pie chart, first, highlight the data. The Excel data we will use is about the units sold per brand.

In this example, we will show you how to create a pie chart from a sales report of a cell phone store. You will need less explanation if you have to present your data to your boss, client or whoever you work with or for.

Not only a pie chart can make it easier for you to analyze data. The pie chart itself is one of the common chart forms used in Excel. Creating a pie chart in Excel is not a hard job since there is a feature you can use to do so. To ease your job in analyzing data in Excel, it’s a great idea to turn your data into a pie chart.

Create pie chart in excel from data