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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks