Almost everything relating to automating histograms in excel points bac
to a technical Microsoft infomation sheet. Its address is
How to create an Excel histogram by using Automation and Analysi
ToolPak
http://support.microsoft.com/default...b;en-us;270844

Their article hints at a solution but doesn't produce a practica
answer for me.

I use Excel 2000 To extract numbers from a database. The numbers o
lines of data and the values vary day by day. All other charts an
graphs automatically update themselves as the data changes. I presum
this doesn't happen with the Histogram tool because it is an add-in.
have tried to use the macro record facility using relative addressing t
automate the process with the histogram utility in the Analysis Toolpa
add-in. While the histogram utility window is open, keyboar
keystrokes are not recorded.

I would like a macro that refreshes the histogram insitu on th
original worksheet, ie not adding a new sheet each time. Their worke
example creates a new application every time

--
Ian
-----------------------------------------------------------------------
Ian B's Profile: http://www.excelforum.com/member.php...fo&userid=3146
View this thread: http://www.excelforum.com/showthread.php?threadid=49621