histogram from cells with formulas

[supersonikk]

Hi all,

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

 

[Jon Peltier]

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

 

[Dave Curtis]

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