In Excel, can you overlap two histograms on the same chart?
- Gary ELv 61 decade agoFavorite Answer
Yes you can.
If you build your histogram as described in http://www.ncsu.edu/labwrite/res/gt/gt-bar-home.ht... you would create two columns of observations, one column of bin limits and two columns of frequencies each using a column of observations and both using the column of bin limits. The last three columns must be contiguous so you can select them as described next.
Then select all of the bin limits and frequencies and create a bar chart from them. In step 2 of the wizard, using the Series tab, you will need to remove the first data series that the wizard created because that is from the bin numbers, and you will need to select that column for the Category (x) axis labels.
The resulting graph will show two sets of histograms that overlap to the extent dictated by the observation data.