Hi,

You need to use named ranges in order for the chart to update automatically.
See Jon Peltier's article on dynamic charting.
http://pubs.logicalexpressions.com/P...cle.asp?ID=246

Chees
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 entered. Is this possible? If
so...how?

Thanks in advance

--

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