View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
steve65 steve65 is offline
external usenet poster
 
Posts: 1
Default Creating a distribution chart


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


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