software

I have a range of 60 different ages and would like to know how to make a
graph (bar and line) that dipicts them in 5 or 10 year increments rather than
individually. How can I do this?

Let's assume your ages are in A1:A60. In B2:B11, enter the numbers 10, 20,
.... 100 (that should be enough, eh?), and put quot;Olderquot; into B12. Select
C2:C12 with C2 as the active cell, type this formula

=FREQUENCY(A1:A60,B2:B11)

and hold CTRL SHIFT when you press Enter, so you enter it as an array
formula. The resulting values show C2: number of values less than or equal
to 10, C3: number of values greater than 10 and less than or equal to 20,
etc.

Now you can make a column chart (i.e., histogram) with the data in columns B
and C.

This is covered in these web pages:

peltiertech.com/Excel/Charts/Histograms.html
peltiertech.com/Excel/Charts/Histogram.html

and Mike Middleton shows how to make nice histograms without too much work
he

www.treeplan.com/better.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______

quot;Lindsayquot; gt; wrote in message
...
gt;I have a range of 60 different ages and would like to know how to make a
gt; graph (bar and line) that dipicts them in 5 or 10 year increments rather
gt; than
gt; individually. How can I do this?
Thank you that was helpful!

Can I change the X axis to reflect the range I selected (10-20, 20-30,
etc.)? Right now it just numbered the categories 1-7. Thank you!

quot;Jon Peltierquot; wrote:

gt; Let's assume your ages are in A1:A60. In B2:B11, enter the numbers 10, 20,
gt; .... 100 (that should be enough, eh?), and put quot;Olderquot; into B12. Select
gt; C2:C12 with C2 as the active cell, type this formula
gt;
gt; =FREQUENCY(A1:A60,B2:B11)
gt;
gt; and hold CTRL SHIFT when you press Enter, so you enter it as an array
gt; formula. The resulting values show C2: number of values less than or equal
gt; to 10, C3: number of values greater than 10 and less than or equal to 20,
gt; etc.
gt;
gt; Now you can make a column chart (i.e., histogram) with the data in columns B
gt; and C.
gt;
gt; This is covered in these web pages:
gt;
gt; peltiertech.com/Excel/Charts/Histograms.html
gt; peltiertech.com/Excel/Charts/Histogram.html
gt;
gt; and Mike Middleton shows how to make nice histograms without too much work
gt; he
gt;
gt; www.treeplan.com/better.htm
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; PeltierTech.com/
gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; _______
gt;
gt; quot;Lindsayquot; gt; wrote in message
gt; ...
gt; gt;I have a range of 60 different ages and would like to know how to make a
gt; gt; graph (bar and line) that dipicts them in 5 or 10 year increments rather
gt; gt; than
gt; gt; individually. How can I do this?
gt;
gt;
gt;

In another range, say D212 (or rearrange this to put it to the left of the
FREQ formulas), enter the labels you want. For the first and last, use lt;10
and gt;100. For the ones in between you can use something like this in D3:

=B2amp;quot;-quot;amp;B3

and drag this down to fill D311.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______

quot;Lindsayquot; gt; wrote in message
...
gt; Thank you that was helpful!
gt;
gt; Can I change the X axis to reflect the range I selected (10-20, 20-30,
gt; etc.)? Right now it just numbered the categories 1-7. Thank you!
gt;
gt; quot;Jon Peltierquot; wrote:
gt;
gt;gt; Let's assume your ages are in A1:A60. In B2:B11, enter the numbers 10,
gt;gt; 20,
gt;gt; .... 100 (that should be enough, eh?), and put quot;Olderquot; into B12. Select
gt;gt; C2:C12 with C2 as the active cell, type this formula
gt;gt;
gt;gt; =FREQUENCY(A1:A60,B2:B11)
gt;gt;
gt;gt; and hold CTRL SHIFT when you press Enter, so you enter it as an array
gt;gt; formula. The resulting values show C2: number of values less than or
gt;gt; equal
gt;gt; to 10, C3: number of values greater than 10 and less than or equal to 20,
gt;gt; etc.
gt;gt;
gt;gt; Now you can make a column chart (i.e., histogram) with the data in
gt;gt; columns B
gt;gt; and C.
gt;gt;
gt;gt; This is covered in these web pages:
gt;gt;
gt;gt; peltiertech.com/Excel/Charts/Histograms.html
gt;gt; peltiertech.com/Excel/Charts/Histogram.html
gt;gt;
gt;gt; and Mike Middleton shows how to make nice histograms without too much
gt;gt; work
gt;gt; he
gt;gt;
gt;gt; www.treeplan.com/better.htm
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt;gt; PeltierTech.com/
gt;gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt;gt; peltiertech.com/Excel/ExcelUserConf06.html
gt;gt; _______
gt;gt;
gt;gt; quot;Lindsayquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have a range of 60 different ages and would like to know how to make a
gt;gt; gt; graph (bar and line) that dipicts them in 5 or 10 year increments
gt;gt; gt; rather
gt;gt; gt; than
gt;gt; gt; individually. How can I do this?
gt;gt;
gt;gt;
gt;gt;