histogram from cells with formulas
 

Hi all,

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


--
Thanks,
Marko

histogram from cells with formulas
 

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

histogram from cells with formulas
 

Hi Marko,

As long as the formula returns a number, then yes. Even if it returns text,
you can always use another formula to count each text entry and do a
histogram from that.
Excel's built-in histograms are somewhat ugly, but there are plenty of
examples of custom histograms on various excel sites.

Dave

url:http://www.ureader.com/msg/10296110.aspx