When it comes to making pie charts this attractive, it doesn’t get much easier than this. Now you have a spiffy-looking pie chart in your Microsoft Excel spreadsheet. After adding a pie chart, you can add a chart title, add data labels. But, as an example, I’ve customized my chart using the tools outlined in the three screenshots below. Select the data and go to Insert > Insert Pie Chart > select chart type. The only way to really learn what you can do is to play around with the different settings for a while. This includes a total of three different tabs: Design, Layout, and Format.Įach tab from the Chart Tools ribbon area will let perform several different customizations. When you have the chart selected (click on the chart), Chart Tools will appear on the ribbon.
:max_bytes(150000):strip_icc()/ExplodeChart-5bd8adfcc9e77c0051b50359.jpg "how to make a pie chart in excel 2013")
The next thing we’re going to do is customize the chart to make it more appealing. Pie chart option in the Charts group on the Insert tab PowerPoint > Chart > Pie, and. Now your pie chart should show up on your spreadsheet. Excel > Insert Pie or Doughnut Chart, and then pick the chart you want. Go to the Home tab and choose Copy as a picture. Select worksheet range, chart or whatever you want to copy. As you see in post title image, I have a solution and it’s pretty simple. The second chart, with one added decimal digit of precision, correctly displays 33. The same thing with PowerPoint sometimes you want some static chart or table image, but picture quality becomes a real problem. However, the first chart reports percentages of 34, 33, and 33. 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. Each pie wedge is 1/3 of the total, 33.333333, rounded to 33. Be sure not to select the cells where you totaled things up. This literally means holding down the left mouse button and dragging a box around the data.
Select the data that you want to include in the pie chart. You can make it look snazzy by styling it from the Home ribbon, but this won’t affect our pie chart. This is pretty easy, one column is your description of the numbers, and the other column is your numbers.
How to make a pie chart in excel 2013 how to#
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.įirst, you’ll need to write your list of data in Excel. Make a Pie Chart in Microsoft Excel 2010 or 2007
0 kommentar(er)
