Category Archives: Charts

Quality Management 5: Pareto Chart

Pareto 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.

Pareto chart Quality Management

Continue reading Quality Management 5: Pareto Chart

Quality Management 4: Histogram (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: Histogram in Excel

Continue reading Quality Management 4: Histogram (any version of Excel)

In-depth: Excel Recommended Charts

Now that we know about Excel 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.

Excel recommended charts

Photo credit: Elsie esq. / Foter / CC BY and salendron / Foter / CC BY-NC-SA

Continue reading In-depth: Excel Recommended Charts

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 blindly created billions of times everyday – why? Because boss wants it that way!

In this article, I am going to attempt to change the mindset of all users of Charts. Please spend 5 minutes of your time reading this article and trying out a new thought process. I am confident that it will add value to your life.

Excel Recommended Charts

Photo credit: Elsie esq. / Foter / CC BY and salendron / Foter / CC BY-NC-SA

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