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