This web page describes the process to link cells to axis parameters:
http://peltiertech.com/Excel/Charts/...nkToSheet.html
Tushar Mehta (
http://tushar-mehta.com) has a free AutoChart Manager utility
that automates this process.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______
"garyboom" wrote in message
...
I'm trying to dynamically create some charts that move by date. I would
like
to also be able to change the scale of the axis. Basically, I want the
max
value +10 and the min value -10. Is there a way to change the axis values
by
linking to a cell instead of entering a value?