ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to control y scaling from worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/82349-how-control-y-scaling-worksheet.html)

Marko Pinteric

How to control y scaling from worksheet
 
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



Jon Peltier

How to control y scaling from worksheet
 
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




Marko Pinteric

How to control y scaling from worksheet
 

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





Jon Peltier

How to control y scaling from worksheet
 
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






All times are GMT +1. The time now is 04:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com