View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Middleton
 
Posts: n/a
Default Automatic Histogram with Inputs

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. <


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