Marko -
You need to use VBA to do this for you. Here is the necessary code:
http://peltiertech.com/Excel/Charts/...nkToSheet.html
If you want a ready-to-use solution, try Tushar Mehta's AutoChart Manager
add-in, available as a free download at
http://www.tushar-mehta.com.
- 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
_______
"Marko Pinteric" wrote in message
...
Dear experts!
I know it is possible to control source data ranges from worksheet.
Is there a way to control y scaling (minimum, maximum) from worksheet too?
Thanks for answers,
Marko