That is, choose the middle of the three pies shown under the heading 2-D Pie.

In this case, the chart we want is this one. Pie charts are among the most popular graphs to make because you can show data. You can also manually drag and drop the corners of the chart to change its appearance. Drawing a pip chart is the same as drawing almost any other chart: select the data, click Insert, click Charts and then choose the chart style you want. One of the most exciting things you’ll do in Excel is converting heaps of dreary data into stunning graphs and charts. The first button lets you add new chart elements, the second button is for modifying the style of the chart, and the third button lets you filter data in the chart.

You can also use the legend that appears on the right-hand side to edit and customize your chart. You can use the Design tab to change the appearance of the chart. Select the icon for Pie Charts.Ī pie chart with your data will now appear on the spreadsheet. Make sure you include column titles and row headings if you want them to appear in the chart.Ĭhoose the Recommended Charts button to see the program’s suggestions for visualizing your data.Īlternatively, go to Chart to see all available types of charts. Start by selecting the data you want to see in your chart. This is very useful when you want to visualize your data and show the proportion of the whole that each value constitutes. This video will show you how to create pie charts in Excel. Excel Help - How to Create a Pie Chart in Excel 2013

Advanced pie charts in excel 2013