#How ot make a pie chart in excel how to
#How ot make a pie chart in excel series

Once you’ve selected the most applicable chart for you, click it so that it can be added to your page in Excel. Click the Insert menu and click the small arrow under Pie in the Charts group to see a drop-down menu with icons of available pie chart styles.However, you can hover the cursor over your preferred pie chart option to see a sneak preview of what it will look like for your data. Click the Insert Tab in the ribbon In the Charts group, click on the Insert Pie or Doughnut Chart. This includes 2-dimensional and 3-dimensional pie charts. Select the entire dataset Click the Insert tab. I can't seem find any thing in the chart options. I can make the actual chart box larger, but there isn't enough room on the page. Whenever I drag the points on the chart, the pie pieces become separated.

#How ot make a pie chart in excel how to

You should now be able to see various options for creating your pie chart. I have a very simple pie chart, but I can't figure out how to make the actual pie larger.I have also selected a dramatic black background for my piechart from the 'ChartStyles' on the 'Design Tab'. You can choose from a 2-D or 3-D piechart. Click on the 'Insert Tab', and select 'Pie' from the 'Charts group'. Then click the Insert Pie or Doughnut Chart option (you can’t miss it, it’s in the shape of a small pie chart). Select the cells in the rectangle A23 to B27.

Select the chart type you want to use and the chosen chart will appear on the worksheet with the data you selected. Then click the Insert tab, and click the dropdown menu next to the image of a pie chart. Do not select the sum of any numbers as you probably don’t want to display it on your chart. To create a pie chart in Excel 2016, add your data set to a worksheet and highlight it. Locate the Labels group and click on the Layout tab.

#How ot make a pie chart in excel series

In your spreadsheet, highlight the data that you want to plot on your pie chart. Clicking on the data series or a specific data point will open the Chart Tools tab.

If you opt to label your data then these will be transferred to your pie chart later on.

Create your columns or rows of data (or both if need be).

Though there are different types of pie charts available to choose from on Excel, it won’t be difficult finding the perfect way to showcase your data.Īll you need to do is follow these steps and you’ll be on your way to visualizing your data in no time at all!

This is the most straightforward way to create a pie chart in Excel.