How to Create A Pie Chart in Excel

To ease your job in analyzing data in Excel, it’s a great idea to turn your data into a pie chart. Creating a pie chart in Excel is not a hard job since there is a feature you can use to do so.

The pie chart itself is one of the common chart forms used in Excel. Not only a pie chart can make it easier for you to analyze data. You will need less explanation if you have to present your data to your boss, client or whoever you work with or for. In this example, we will show you how to create a pie chart from a sales report of a cell phone store. The Excel data we will use is about the units sold per brand.

To turn the data like the one above into a pie chart, first, highlight the data.

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.

A pie chart will appear once you click a chart style.

How to customize your pie chart

Everyone never gets satisfied with something default. If you don’t like the default look of your pie chart, you can change its style. To do so, click your pie chart followed by Chart Styles. There are 12 different styles offered by Excel. You can also change the default color by going to the Color tab on the popup.

To change the legend location and data label, you can click the plus icon on the popup.

Alternatively, you can also go to the Design tab to customize your pie chart. Here, you will find several tools to customize your pie chart.

If you want to change the colors and styles of individual elements, you can go to the Format tab. 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).


Please enter your comment!
Please enter your name here