| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automate Macro | Excel Discussion (Misc queries) | |||
| Automate Import/Export | Excel Discussion (Misc queries) | |||
| How can I automate the naming of worksheet tabs? | Excel Discussion (Misc queries) | |||
| Can a register automate a memo for none attendance? | Excel Discussion (Misc queries) | |||
| automate creation of sheets in excel | Excel Worksheet Functions | |||
Linear Mode
