how to create pie chart in excel from a worksheet

The Excel chart shortcut key is F11 in Windows. This button will allow you to change the color themes for the chart. You'll also see the Change Colors button to the the left of the designs. This will allow you to browse and select from various chart designs. Once you've created the chart, you should see a dropdown arrow. Some versions of Excel will let you hover over a chart type to view a preview chart of your data before you click and commit to one. You'll see a pop-up window containing several pie chart types, including 3D pie charts.

Create a chart from a table in ExcelĪfter you've selected the cell range for your chart, click the Insert tab, then click the pie chart icon next to the 'Recommended Charts' button. In some cases, Excel can determine the dataset to use based on the arrangement of your cell values however, it's better to select the cells that you'd like to use to populate the chart. Pie charts are generated from row and column values in your spreadsheet. The following table is an example of spreadsheet data that can be represented as a pie chart in an Excel spreadsheet: Pie LabelĮxcel will automatically add the values for each item and calculate the percentages for you. The data should contain a column for the pie labels and another column for the numerical values that represent the size of each pie slice. You'll also need to create some numerical test data for the pie charts you want to generate. Prerequisitesīefore proceeding with this tutorial, you'll need to install a supported version of Microsoft Office on your Mac or Windows machine. In this article, we'll walk you through the process of creating an Excel pie chart and saving that chart as an image.

Microsoft Excel makes it easy to generate pie charts from your spreadsheet data. Pie charts offer a simple way to visualize proportions and percentages in your data, with each 'pie slice' representing one of those percentages.

How to create pie chart in excel from a worksheet