The chart doesn't know whether the cell contains a calculated value or a
hard-coded value.

Did you encounter some kind of error? Perhaps the formula returned a
non-numeric text string that only looks like a number to mere mortals like
us.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"supersonikk" wrote in message
...
Hi all,

Can I make a histogram from cells containing formulas, or does it have to
be
a numerical text entry?


--
Thanks,
Marko