software

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
Marko -

You need to use VBA to do this for you. Here is the necessary code:

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 www.tushar-mehta.com.- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______

quot;Marko Pintericquot; gt; wrote in message
...
gt; Dear experts!
gt;
gt; I know it is possible to control source data ranges from worksheet.
gt;
gt; Is there a way to control y scaling (minimum, maximum) from worksheet too?
gt;
gt; Thanks for answers,
gt;
gt; Marko
gt;

So VBA is the only way.

Thanks for the answer.

Marko

Jon Peltier wrote:
gt; Marko -
gt;
gt; You need to use VBA to do this for you. Here is the necessary code:
gt;
gt; peltiertech.com/Excel/Charts/...nkToSheet.html
gt;
gt; If you want a ready-to-use solution, try Tushar Mehta's AutoChart Manager
gt; add-in, available as a free download at www.tushar-mehta.com.
gt;
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; PeltierTech.com/
gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; _______
gt;
gt; quot;Marko Pintericquot; gt; wrote in message
gt; ...
gt;
gt;gt;Dear experts!
gt;gt;
gt;gt;I know it is possible to control source data ranges from worksheet.
gt;gt;
gt;gt;Is there a way to control y scaling (minimum, maximum) from worksheet too?
gt;gt;
gt;gt;Thanks for answers,
gt;gt;
gt;gt;Marko
gt;gt;
gt;
gt;
gt;

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

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 -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______

quot;Marko Pintericquot; gt; wrote in message
...
gt;
gt; So VBA is the only way.
gt;
gt; Thanks for the answer.
gt;
gt; Marko
gt;
gt; Jon Peltier wrote:
gt;gt; Marko -
gt;gt;
gt;gt; You need to use VBA to do this for you. Here is the necessary code:
gt;gt;
gt;gt; peltiertech.com/Excel/Charts/...nkToSheet.html
gt;gt;
gt;gt; If you want a ready-to-use solution, try Tushar Mehta's AutoChart Manager
gt;gt; add-in, available as a free download at www.tushar-mehta.com.
gt;gt;
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt;gt; PeltierTech.com/
gt;gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt;gt; peltiertech.com/Excel/ExcelUserConf06.html
gt;gt; _______
gt;gt;
gt;gt; quot;Marko Pintericquot; gt; wrote in message
gt;gt; ...
gt;gt;
gt;gt;gt;Dear experts!
gt;gt;gt;
gt;gt;gt;I know it is possible to control source data ranges from worksheet.
gt;gt;gt;
gt;gt;gt;Is there a way to control y scaling (minimum, maximum) from worksheet
gt;gt;gt;too?
gt;gt;gt;
gt;gt;gt;Thanks for answers,
gt;gt;gt;
gt;gt;gt;Marko
gt;gt;gt;
gt;gt;
gt;gt;