Creating charts from formula results

[Boba Fett]

Im trying to create a chart in Excel based on the reult of a column or formula's I wrote. The chart just seems to show the formula as its values, can anyone help?

I had a list of employee ages and used a formula to indicate their age bracket (e.g. 16-24, 25-30, 31-40 etc). I now want a bar chart that will show how many employee's are in each bracket.

Help is much appreciated asap as its for my job. Thanks in advance.

[Richard Neville]

Sometimes it is neater to reproduce the information for a chart in an area
of the sheet that does not print. You need several headings (16-24, etc.)
which could go on one line, and the corresponding values on the next line.
Then select all the active cells in these two lines and construct the chart
from there. If the values might chance, make the value cells cross-reference
the cells where the actual formula results reside (e.g. cell F2=B7).

"Boba Fett" <[email protected]> wrote
in message news:[email protected]...
>
> Im trying to create a chart in Excel based on the reult of a column or
> formula's I wrote. The chart just seems to show the formula as its
> values, can anyone help?
>
> I had a list of employee ages and used a formula to indicate their age
> bracket (e.g. 16-24, 25-30, 31-40 etc). I now want a bar chart that
> will show how many employee's are in each bracket.
>
> Help is much appreciated asap as its for my job. Thanks in advance.
>
>
> --
> Boba Fett
> ------------------------------------------------------------------------
> Boba Fett's Profile:
> http://www.excelforum.com/member.php...o&userid=26509
> View this thread: http://www.excelforum.com/showthread...hreadid=397767
>