# Movie Rating Chart

I see lot of movies. I am the First-Day-First-Show guy. Usually, I post the Movie Rating on my personal FB page. See some examples below. But recently I posted a Movie Rating Chart. Here is how you do it.

# How to create Custom Data Labels in Excel Charts

I received a query from a customer about dynamic data labels for charts. Instead of replying directly, I thought of writing this article. This will help all of you in refining your charts. The idea is to create a chart which explains the fluctuations using text based explanations. The best part is, the explanation can be a part of the data itself.
Watch the two minute video and read details below. This works with Excel 2013 onwards. I have also included the solution for older versions, which is not as elegant, but it works.

# Quality Management 6: Scatter Chart

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: Histogram and Pareto

Read Histogram and Pareto articles first. Excel Data Analysis tool can create a Pareto chart while creating a histogram. Small tweak but very useful.

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

# Quality Management 4: Histogram in 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: Histogram using Pivot Table

This is continuation of the previous article. In this article, we will see another way of creating Histogram using Pivot Table.

# 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 3: Create Run Charts in Excel

Run charts are simple line charts 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: 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.