How to control y scaling from worksheet

  • Thread starter Thread starter Marko Pinteric
  • Start date Start date
M

Marko Pinteric

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:

http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.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
_______
 
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 here:

http://peltiertech.com/Excel/Charts/ChartIndex.html#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
_______
 
Back
Top