Select the chart title, delete the current title and replace it with an appropriate chart title.From the list, choose any of 2-D Pie, 3-D Pie or Doughnut.On the Insert tab, under Charts group, select the Pie Chart icon.Select the range of data, as shown below.You can also copy and paste the data in a worksheet. To make pie charts in Excel, do the following: The table shows the level of students’ responses in a Chemistry class of 87 students. To illustrate how to make pie charts in excel, let’s use the following table. In Microsoft Excel, there is a Recommended Charts command this command helps a user to choose the appropriate chart for the data in the view.

It also shows the relationship between the different parts of the data. Charts are used to summarize large tabular data for easy understanding. Used to combine two charts for two different values to highlight different types of informationĬharts or graphs are graphical representations of data. Use to display the trend of stocks or forex over time, especially when there are different price values Use to show values relative to a center point Use to show trend values across two dimensions

Use for financial data to show the cumulative effect of a series of positive and negative values Use to show the relationship between two sets of data Use to display the variations within data categories Use to compare values arranged hierarchically using a ring, especially when there are many categories of data Use to compare values arranged hierarchically using different rectangular levels, especially, when there are few categories The whole equals 100%, each proportion is derived from the 100%. Use to show the proportion of a category from the whole. Use to display trend values, especially, when there is a need to highlight the magnitude of change over time. Use to display trend values over time, especially, when there are many data points Use to compare values across different categories, especially, when categories name is long Use to compare values across different categories Let us list the different types of charts in Excel 2016 and the nature of the data suitable for them. The type of chart you can choose to represent your data depends on the nature of your data. Microsoft Excel 2016 has about 15 types of charts you can choose from.

Create pie chart in excel from data