# Quality Management 6: Scatter Diagram

When you have two columns of numeric data, Scatter chart helps you understand how they affect each other (jargon: correlation). Creating a scatter plot is easy. But interpretation can be misleading or even absurd. Let us explore how to create effective Scatter plots.

# Quality Management 5: Pareto Chart

This chart is used to analyze important factors and prioritize action items. It is a combination of bar and line chart. Bar chart shows the data in descending order of importance and line chart shows cumulative percentage. It is popularly known as the 80:20 rule. We will see three ways of creating this chart using Excel.

# Quality Management 4: Histogram (using Excel 2016)

Well, the histogram articles don’t seem to be ending. I promise, this is the last one. With Excel 2016, a new chart type called Histogram was introduced. Now we don’t need either Data Analysis ToolPak or Pivot Table to create a histogram. Have a look.

# Quality Management 4: Histograms (any version of Excel)

Histogram is used to visualize the frequency with which data occurs. This is a good way of understanding data more than just sum and average. It is a good idea to look at each data set you get as a histogram. Here is how you do it in Excel.

# Quality Management 3: Run Charts

It is a simple line chart drawn against time. The idea is to visualize the pattern and trend of captured data. The data could be about defects, issues, observations or variability. Let us see how to manage this using Excel.

# In-depth: Recommended Charts

Now that we know about Recommended Charts, let us explore it in-depth. This is an implementation of artificial intelligence or machine learning at your fingertips. Don’t underestimate it… exploit it.

# Don’t just make charts the way boss wants. Use Recommended Charts

There are two types of charts. First type is a chart which you create to interpret data more effectively. The second type is more common. These charts are created billions of times everyday – why? Because boss wants it that way!