Simple graph

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sohum.shah@gmail.com - 27 Oct 2006 18:18 GMT

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.

Reply to this Message

Bernard Liengme - 27 Oct 2006 19:03 GMT

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

Signature

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

>I have a chart with zip codes and a population rate.
>
[quoted text clipped - 14 lines]
>
> Thank you.

Reply to this Message

sohum.shah@gmail.com - 27 Oct 2006 19:29 GMT

thank you for all your help on all my posts.

On Oct 27, 12:03 pm, "Bernard Liengme" <blien...@stfx.TRUENORTH.ca>
wrote:

> 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
[quoted text clipped - 30 lines]
>
> > Thank you.

Reply to this Message