Simple graph

S

sohum.shah

I have a chart with zip codes and a population rate.

ZIP RATE
80001 2.34
80002 1.23
80003 1.23


I want to make a chart that has the rate on the x axis and the number
of times that rate occurs on the y axis.

|
|
| *
|
| *
|_________________________________
| |
1.23 2.34


Thank you.
 
B

Bernard Liengme

I will assume the ZIP and RATE stuff is in A1:B200 (labels in row 1)
Label in G1 to read RATE (but leave it empty for now), label in H2 to read
COUNT
Make a list of rates in G2:G20 (say)
In H2 =COUNTIF($B$2:$B$200,G2)
Copy down the row
Select H1:G20 and make a LINE chart
A label in G1 would make Excel treat G as a data series not a category
series
best wishes
 
S

sohum.shah

thank you for all your help on all my posts.

I will assume the ZIP and RATE stuff is in A1:B200 (labels in row 1)
Label in G1 to read RATE (but leave it empty for now), label in H2 to read
COUNT
Make a list of rates in G2:G20 (say)
In H2 =COUNTIF($B$2:$B$200,G2)
Copy down the row
Select H1:G20 and make a LINE chart
A label in G1 would make Excel treat G as a data series not a category
series
best wishes
Click to expand...
 
Top