Legend: The legend is an indicator that helps distinguish between data categories.It’s always a good idea to enter a descriptive label to define the chart. Plot Area: This is where the graphic representation takes place.Let us show you how to make a pie chart in Excel and use them in your dashboard reports! You can download our sample workbook here. Pie charts commonly used in dashboard reports, and are great for creating an overview of underlying items.Įxcel has a plethora of options for pie charts that you can choose from. Note that pie charts can only show single series of data, and are best used with data that doesn’t contain too many categories - The chart can become hard to interpret if it has too many slices. Each slice is drawn proportional in size to represent the contribution of each item to the whole. University of Wisconsin-Eau Claire 105 Garfield Avenue P.O.A pie chart is a graphic representation of data on a circle divided into a number of slices. Changing the Chart Typeįrom the Chart menu, select Chart Type.Ĭlick and drag the selected slice outward. You can also explode only a single pie slice. If you have already created a pie chart, you can make it an exploding pie chart by changing the chart type or by manually exploding the pie slices. NOTE: For more information, refer to Using the Chart Wizard. Under Chart sub-type, select one of the exploded pie charts. The Chart Wizard - Step 1 of 4 - Chart Type dialog box appears.įrom the Chart type scroll box, select Pie. On the Standard toolbar, click Chart Wizard.

NOTE: For more information about creating charts, refer to Creating a Basic Chart. If you have not yet created your pie chart, use these instructions to create an exploding pie chart. For more information about creating charts, refer to Creating a Basic Chart. In Excel, you can drag the pie slices outward to explode all of the slices away from each other. This article is based on legacy software.Įxploding a pie slice can be used to draw attention to a specific portion of the pie. (Archives) Excel 2003/2004: Creating Exploding Pie Charts

Make a pie chart in excel