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

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

# Caution: Visual Interpretation Error in Data Analytics

We have seen how to put data bars in Excel (Bar charts with a difference). These help us compare any value with any other value visually. This helps us understand patterns in the data.

If not used properly, this great feature can lead to confusion and misinterpretation as well. Here are common scenarios and the solutions.

# Quick Analysis should NOT be done quickly!

Read the previous article to understand the context of this article. Quick Analysis gives you many types of data visualizations instantly. But that is NOT the real benefit. The real benefit – as usual – is elusive and difficult to grasp in this “instant” mode of living life.

Read on to find out what you are missing – even if you know how to use Quick Analysis!

# Quick Analysis in Excel – Have you even noticed it?

Feature introduced in 2013 for quick analysis in Excel. Brilliant implementation. But no use. Because nobody noticed it. Those who noticed it did not understand EXACTLY how to use it. Sad story.

# Bar charts with a difference

We are used to bar charts. But do you know that we can add bar charts within cells? Have a look and see what you were missing all this while! (These have been there for 8 years).

# Which type of chart to use when? No worries. Excel will help you!

Lot has been written about it. With Excel 2013, Microsoft did the smartest thing. They added a chart type called Recommended Chart. Now Excel is smart enough to look at what data you have selected and choose the most appropriate chart types for you.

It shows the preview of those charts using YOUR data.

Final decision, of course, is yours. So you choose the one which depicts the information in the most relevant way. Also notice a feature called Recommended Pivot Tables.

The most important thing is to STOP using the habitually familiar chart and explore what recommendations are given by Excel. It is not about making the chart which someone is asking for.

### It is about finding out every piece of useful information from available data and to use it to your advantage. By the way, that THOUGHT PROCESS is called Business Intelligence!

It is also a part of Quick Analysis feature (which we will cover in the next article).

# 3D map – Time Animation – Part 2

Showing familiar data on a map and that too with time animation added is a completely new and powerful way of visual thinking and analysis.We will continue to explore three different way of showing time based data.

# 3D Map with Date/Time based animation: In-depth

Power Map series article 3. We will explore how to plot and interpret date/time type of information visually on the 3D map. This type of visualization is new to most of us.Therefore, this article clarifies the core concepts by taking a very simple example.