histogram comparing two variables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to graph an histogram to compare two variables with the same bins,
although the ranges between the minimum and maximum are different. Anybody
knows how to do it? Thanks!
 
Hi Monica -

On this web page, I describe how to make histograms, first using the Analysis Toolpack, then a
more flexible way using your own worksheet formulas:

http://peltiertech.com/Excel/Charts/Histograms.html

Scroll down about 2/3 of the page to "Dynamic Do-It-Yourself Histograms". The nice thing about
this approach is that you can set up your own bins, and calculate the frequencies of two sets of
data against the same bins, side by side. With side by side data, you can easily make a
clustered column chart to directly compare the two populations. Where the min and max are
different, one will have values and the other will be zeros.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top