Automate a Graph?

[pugsly8422]

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]

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