Scaling of graphs through formulas

[Hari Prasadh]

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

 

[Jon Peltier]

Hari -

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

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

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

 

[Hari Prasadh]

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]

Must have been a temporary thing. It's up now, and partial statistics
for today indicate normal incoming traffic.

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

 

[Hari Prasadh]

Hi Jon,

After 5/6Hrs I could acces your site and got the requisite information.

Thnx for your help.

Regards,
Hari
India