Histograms are useful tools to visualise the distribution of data. They are very often associated with bell-shaped curves to illustrate if data are normally distributed (or not). Excel has simple to use tools to draw a histogram based on a single variable - if you have two data sets, you can draw two histograms and compare. While this works in a lot of cases, sometimes it is useful to be able to draw a single diagram which contains two or more distributions, so that you can see where the distributions overlap.
To create overlapping histograms in Excel you need to know how to use Pivot Tables, but they are easy to use and allows us to draw overlapping histograms with ease. I have published a new video today showing how to to this step-by-step. Enjoy!
Post a Comment