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
A Candlestick chart is a built-in chart type in Excel normally used to show stock price activity. You’ll find this chart under the Stock category of chart types, with the name Open-High-Low-Close, sometimes abbreviated OHLC.
This chart type automatically plots the full range of values as a single line, with indicates high and low in a given time interval. On top of the line is a bar which indicates open and close values. Dark bars indicate close price is less than open price (a loss), light bars indicate a close price greater than open price (a gain).
Excel plots this chart in blank and white only by default.
Pros
- Quickly plot stock data in open high low close format
- At a glance indication of stock price activity
Cons
- Not as well understood as many other chart types
- A specific chart type mostly seen in the financial world
