This is continuation of the previous article. In this article, we will see another way of creating Histograms using Pivot Tables.
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.
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.
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!
Feature introduced in 2013. Brilliant implementation. But no use. Because nobody noticed it. Those who noticed it did not understand EXACTLY how to use it. Sad story.
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).