Automatic Histogram with Inputs

J

J

Hi! I know how to use the histogram tool, but I was wondering if there's a
way to make it so that if a user changes some of the input values manually,
the histogram calculations are changed as well. Thanks in advance.
 
M

Mike Middleton

J -
Hi! I know how to use the histogram tool, but I was wondering if there's a
way to make it so that if a user changes some of the input values
manually, the histogram calculations are changed as well. Thanks in
advance. <
Click to expand...

The Histogram tool produces static results.

If you want dynamic output, consider using the FREQUENCY array-entered
worksheet function to obtain the frequency distribution with a Column chart
type to display the function results.

- Mike
www.mikemiddleton.com
 
Top