Well, no. I use a non-VBA worksheet function technique in some proprietary
workbooks. It's complex enough that I can't do it justice in a newsgroup
post, and I have not had time to generate a web page describing it.
Basically it requires calculating appropriate axis scale parameters (based
on the data or on user overrides), scaling the data from 0 to 1 (between the
calculated min and max), plotting the transformed data on a scale of 0 to 1,
hiding the regular chart axis, and creating a custom axis based on the
calculated parameters.
The custom axis part is shown he
http://peltiertech.com/Excel/Charts/...tml#axisscales
Several of these links show the use of transformed data. For now you'll have
to come up with your own algorithms for axis scale parameters.
- 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
...
So VBA is the only way.
Thanks for the answer.
Marko
Jon Peltier wrote:
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