1) Sort your data by region (Data | Sort)
2) Make a column of wealth values: maybe 10, 12, 14, ..... 30 This is the
'bin'
3) in column next to BIN use FREQUENCY on the first regions' data
4) In next column use FREQ on second region, etc
5) Plot chart by selecting BIN and as many columns as you have regions
Excel often requires you plan an attack on the problem - not everything is
'pre-bottled'
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"steve65" wrote in
message ...

Sorry that I was so vague. The first column is the net worth of a
person in billons and the second column is one of five regions that
that person lives in. The goal of the project is to chart the
distribution of wealth per region.


--
steve65
------------------------------------------------------------------------
steve65's Profile:
http://www.excelforum.com/member.php...o&userid=37510
View this thread: http://www.excelforum.com/showthread...hreadid=573579