- #How to use microsoft excel to make a pie chart how to#
- #How to use microsoft excel to make a pie chart series#
On the Recommended Charts tab, you can review the suggestions on the left and then check out a preview and brief description on the right. Then, head to the Insert tab and click “Recommended Charts” in the Charts section of the ribbon.Įxcel will analyze your data and provide recommendations in the Insert Chart window. To use the tool, select the data you want to plot in a chart. In addition, Excel can actually help you pick the right graph with its Recommended Charts feature. You can certainly use a different type of graph or chart if you feel it represents your data well. While the above are the most common types of charts to use for the kind of data you have, these aren’t hard and fast rules.
#How to use microsoft excel to make a pie chart how to#
RELATED: How to Create and Customize a Waterfall Chart in Microsoft Excel More Help Choosing a Chart Radar: Use to show values in relation to a center point.Surface: Use to show optimum trends or relations in values across dimensions.Funnel: Use to show decreasing stages in a process.Waterfall: Use to show positive and negative effects to values.There is a handful of other charts in Excel that work for one-off situations and might also fit your data.
RELATED: How to Make a Curved Graph in Excel Other Types of Charts in Excel
#How to use microsoft excel to make a pie chart series#
Doughnut: Use with more than one data series where each relates to a larger amount.Pie: Use with one data series where the whole equals 100 percent.You might show the percentage of sales for each salesperson, visits to a website based on location, or each division’s contribution to revenue, all in relation to the total.įor displaying parts of a whole, you can use one of these chart types:
If you want to show parts of a whole, you can use a composition chart. RELATED: How to Create and Customize a Treemap Chart in Microsoft Excel Excel Charts for Composition Data
Some depend on the number of data sets while others use a hierarchical structure. When you want to compare one set of data to another, you have several chart types that work.