Basic Bar Chart Question

Either way, you have a great site, and the help I've gotten has been
phenomenal.

--Jim

"Jon Peltier" wrote in message
...
Sorry, there's an echo in here!

Jon Peltier wrote:
Jim -

Try this site:

Add a Horizontal or Vertical Line to a Column or Line Chart

http://www.geocities.com/jonpeltier/...s.html#AddLine

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Spike9458 wrote:

DVT ... one more question: How could I add 2 lines to my graph ... one
that
would represent the Average sales price, and one that would represent
the
Median sales price?

--Jim

"dvt" wrote in message
newsprxuyk6usqi5lh2@localhost...
On Thu, 30 Oct 2003 06:55:48 -0500, Spike9458
wrote:


=FREQUENCY($H$2:$H$89,$H98:$H$175)

This is the formula I copied down beside the column I wanted to
graph.
$h$2:$h$89 is the column of data I want to graph (prices range from
$24000
to over $500000 ... results returned "0" in each cell, and nothing
came
up
in h98:h175 ...



The end result is that I want the axis across the
bottom to be the price of a house, in $25000 increments from $100k to
$600k,
and on the vertical axis I want the quantity, so that my graph shows
that X
number of houses were in the $150k-$175k range, and so forth ...
making
sense?



You are pretty close. The second range of values (in your case
H98:H175)
should have numbers you entered. Based on what you say, you want these
values in H98:H118

100,000
125,000
150,000
175,000
....
600,000

Now you should edit your formula to reference H98:H118 instead of
H98:H175. Now put that formula in cell I98. Select cells I98:I119,
making sure I98 is the active cell. Hit F2 to edit the formula, then
array-enter the formula with the keystroke ctrl-shift-enter. Your
formula
should be surrounded by curly braces {} and should be copied down to
all
cells in your selected range.

The results shown in I98:I119 will be the number of values that fit the
bins 0-100k, 100-125k, 125-150k, .... above 600k. You can then chart
I98:I119.

Hope this helps.

--
Dave
dvt at psu dot edu