Hi,

See Jon's article on dynamic charts.
http://pubs.logicalexpressions.com/P...cle.asp?ID=246

Cheers
Andy

pugsly8422 wrote:
I am putting together a daily list of the change in prices of stocks, and
what I want to do is make a graph on another worksheet that will update
whenever enter a new date and amount. Is this possible? If so...how?

Thanks in advance.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info