View Single Post
  #3   Report Post  
Hari Prasadh
 
Posts: n/a
Default

Hi Jon,

Thnx for the post.

(Just now tried to accessed your site, 11th July, 1112 Hrs - India Time but
your site seemed to be down. - Would try to later again and post back if I
have problems).

Thanks a lot,
Hari
India

"Jon Peltier" wrote in message
...
Hari -

With some VBA it's possible to link the axis scale parameters to worksheet
cells:

http://peltiertech.com/Excel/Charts/...nkToSheet.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Hari Prasadh wrote:

Hi,

Is it possible to control the Maximum X scale value and Minimum Y scale
value based on the DYNAMIC changing data in Excel sheet.

Like I would like to set Minimum to 0.9*Min(B1:B15) and Maximum to
1.1*Max(B1:B15) or whatever based on my whims (basically I would like it
to be formula based or linked to a particular cell).

Is that possible?

Thanks a lot,
Hari
India