Automate a graph/chart?
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 |
Automate a graph/chart?
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 |
All times are GMT +1. The time now is 05:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com