steps to create pie chat in excel
Answers
Creating Pie Chart
Select all of your data.
To do so, click the A1 cell, hold down ⇧ Shift , and then click the bottom value in the B column. ...
Click the Insert tab. It's at the top of the Excel window, just right of the Home tab.
Click the "Pie Chart" icon. ...
Click an option. ...
Customize your chart's appearance.
Follow Me!
1. Open a blank worksheet in Excel. Enter data into the worksheet and select the data.
Remember that pie charts only use a single data series. If you select the column headers, the header for the values will appear as the chart title, and you won’t be able to edit the chart.
The pie chart appears on the worksheet.
Other Versions of Excel: The chart types are listed under the Insert tab. This is the only difference.
If you realize there’s an error in the data, there’s no need to start over. Simply update the data on the worksheet and the chart will automatically adjust to reflect the new data. If you’ve copied the chart to another place (excluding other Microsoft Office program), you’ll need to insert the updated chart into the other program. If the chart has been copied into a Microsoft Office program on the same computer, the chart copy will automatically update.
If you only want to display a subset of a long data list, select the data you want to appear in the chart. The rows don’t even have to be contiguous. While the examples used in this article all have data in columns, you can also use data in rows.