Histograms...and buttons

[seweber]

How would a person go about make a button that would update a
histogram
with a macro. I tried recording it but all i got was this 1004 error.
(Application.Run "ATPVBAEN.XLA!Histogram")
It appears that i have both of the add-ins checked. Does anyone know
what is going on with my histogram. Why cant i update it when i click
a button that is suppose to do that one thing.

 

[Mike Middleton]

(e-mail address removed) -

If you don't get a reply regarding the Analysis ToolPak, here are some
alternatives:

(1) Use the array-entered FREQUENCY worksheet function to create a frequency
distribution, and construct a Column chart type from the frequency
distribution. The result will be dynamic, i.e., when the data changes, the
frequency distribution and chart will update automatically.

(2) If you want a macro solution, take a look at the unprotected VBA code in
my Better Histogram add-in, available for download from www.treeplan.com.

- Mike
www.MikeMiddleton.com