Make a Pie Chart in Microsoft Excel 2010 or 2007
Update: If you are running modern versions of Excel in the Microsoft 365 (formerly O365) subscription suite, read how to make pie charts in Excel. First, you’ll need to write your list of data in Excel. This is pretty easy, one column is your description of the numbers, and the other column is your numbers. You can make it look snazzy by styling it from the Home ribbon, but this won’t affect our pie chart.
Select the data that you want to include in the pie chart. This literally means holding down the left mouse button and dragging a box around the data. Be sure not to select the cells where you totaled things up. Once everything is selected, click the Insert ribbon and then click Pie and select whether you want a 2-D or a 3-D pie; and which template.
Customize your chart
Now your pie chart should show up on your spreadsheet. The next thing we’re going to do is customize the chart to make it more appealing. When you have the chart selected (click on the chart), Chart Tools will appear on the ribbon. This includes a total of three different tabs: Design, Layout, and Format.
Each tab from the Chart Tools ribbon area will let perform several different customizations. The only way to really learn what you can do is to play around with the different settings for a while. But, as an example, I’ve customized my chart using the tools outlined in the three screenshots below.
Now you have a spiffy-looking pie chart in your Microsoft Excel spreadsheet. When it comes to making pie charts this attractive, it doesn’t get much easier than this. Do you have a favorite tip or trick for making pie charts in Excel? We’d love to hear it in the comments below.
Comment Name * Email *
Δ Save my name and email and send me emails as new comments are made to this post.
