![what is scatter chart in excel what is scatter chart in excel](https://www.doka.ch/3Dscatterplot_sm.jpg)
When you think of trends, these are things that change over time.
#What is scatter chart in excel how to#
RELATED: How to Create and Customize a Pareto Chart in Microsoft Excel Excel Charts for Trend Data The chart uses quartile, median, minimum, and maximum values.
![what is scatter chart in excel what is scatter chart in excel](http://img.bhs4.com/1d/4/1d40b8773541b142e88f048ac85cb98f75c113ca_large.jpg)
Scatter: Use to show relationships between data sets.Pareto: Use to show the relative portion for each category to the total and include significant factors.Histogram: Use to show the frequency of values sorted into bins.This type of graph works well for things like survey results based on age, frequency of complaints in a call center, or test scores across schools.įor displaying the distribution of data, you can use one of these chart types: If you want to display how a large data set is disseminated, use a distribution chart. RELATED: How to Make a Pie Chart in Microsoft Excel Excel Charts for Distribution Data Stacked Column, Bar, or Line: Use to display parts of a whole that change over time.
#What is scatter chart in excel 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 Bubble: Use with at least three data sets when the third set determines the bubble sizes.Scatter: Use with at least two data sets when the data signifies measurements.Sunburst: Use to show a hierarchical comparison with rings.Treemap: Use to show a hierarchical comparison with rectangles.Column or Bar: Use with two or more data points to show relational differences between categories.For example, you might compare income from various sources or performance in categories for an employee review.įor displaying comparisons, you can use one of these chart types: 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.