Menu

Histograms...and buttons

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.misc

Mike Middleton Mike Middleton is offline

Mike Middleton is offline

external usenet poster

Posts: 762

Default

Histograms...and buttons

-

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

wrote in message
ups.com...
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.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Histograms	Motaad	Excel Discussion (Misc queries)	2	March 20th 07 06:40 PM
histograms	Motaad	Excel Worksheet Functions	0	March 20th 07 04:30 PM
Histograms	NanoNymph	Excel Discussion (Misc queries)	0	March 14th 07 09:00 PM
histograms	just me	Charts and Charting in Excel	1	February 1st 06 10:08 PM
histograms	Stacy U	Excel Discussion (Misc queries)	3	November 11th 05 07:17 AM

All times are GMT +1. The time now is 03:02 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement