Assuming the data you enter is in a table named 'Table 1', create a second table (I named it 'Data Summary'). If you’re using Excel on Windows, you can also use the Chart Elements icon on the right of the chart. In the pop-out menu, select Primary Horizontal, Primary Vertical, or both. Click the Add Chart Element drop-down arrow and move your cursor to Axis Titles. 2) allows you to continue adding entries in the original data table while being able to plot as a pie chart. Select your chart and then head to the Chart Design tab that displays. A pie chart will appear once you click a chart style. 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. To turn the data like the one above into a pie chart, first, highlight the data. 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). 1) arranges the data and categories into a single table already 'set up' for use in a chart. The Excel data we will use is about the units sold per brand. 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.
#HOW TO CREATE PIE CHART IN EXCEL MACBOOK PLUS#
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. Just right-click the pie chart and select Format Data Point. How to customize your pie chartĮveryone never gets satisfied with something default. You can also explode a slice out of a pie chart the other way. 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. The Excel data we will use is about the units sold per brand.
#HOW TO CREATE PIE CHART IN EXCEL MACBOOK HOW TO#
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.