The Bubble Chart is a built-in chart type in Excel. Bubble charts are a special kind of XY chart that can display another data series which is used to scale the bubble (marker) plotted at X and Y values. You can think of a bubble chart as “X versus Y, scaled by Z”. Like a regular XY scatter chart, both axes are used to plot values – there is no category axis.
Pros
- Can show the relationship of one variable to another
- Unique ability to show data about a third dimension
- Can visually display correlation
Cons
- Unusual chart type may be difficult to ready for many people
- More difficult to set up than other chart types
The Pareto Chart is a built-in chart type in Excel 2016. A Pareto chart is a variant of the histogram chart, arranged in descending order for easy analysis. The sequencing is performed automatically, and a separate line is added on a secondary axis to make it easy to see contribution toward 100% as columns are plotted to the left.
Pareto charts highlight the biggest factors in a set of data. Following the idea of 80/20 analysis, they try to show which (approximately) 20% of the categories contribute 80% of the data being measured. They are often used in process improvement to show which factors deserve the most attention.
Pros
- Quickly highlights most important data
- Excel automatically builds histogram and adds Pareto line
Cons
- Less common chart type may be difficult to ready for many people
- Built-in Pareto Chart is not as easy to customize as a standard combo chart
