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.
Continue reading Quality Management 5: Pareto Chart
Capture important moments while conference videos, eLearning, etc. using a powerful OneNote shortcut. These could be specific slides / demos / whiteboard content. Find out how to do it.
Continue reading OneNote: Instant visual notes while watching Videos
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.
Continue reading Quality Management 4: Histogram in Excel 2016
This is continuation of the previous article. In this article, we will see another way of creating Histogram using Pivot Table.
Continue reading Quality Management 4: Histogram using Pivot Table
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.
Continue reading Quality Management 4: Histogram (any version of Excel)