Creating a distribution chart

[steve65]

Hello All,

I have an assignment for my class to create a line graph that shows the
distribution of wealth by region. A sample of the data is shown below.
The only way I can think of solving this problem is to create a separate
histogram for each region and then create a line graph using those
created histograms.

The problem I am having is that Excel only allows one histogram per
worksheet. If I create the histograms on separate worksheets, how
would I create the line chart I need?

Any guidance you can provide would be greatly appreciated.

Steve

wealth region
37 M
24 U
14 A
13 U
13 U
11.7 E
10 M
8.2 U
8.1 U
7.2 E
7 M
6.2 O
5.9 U
5.3 U
5.2 E
5 M
5 M
4.9 A
4.8 U

 

[Bernard Liengme]

What do you mean by "histogram for each region" ? All you have for a given
region is a list of numbers. Maybe you are suppose to add these up.
best wishes

 

[steve65]

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

 

[Bernard Liengme]

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

 

[steve65]

Thank you for the reply back, I will look at this tonight

 

[steve65]

This worked great. Thanks again