Scaling of graphs through formulas
 

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

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

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

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 wrote:
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

Hi Jon,

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

Thnx for your help.

Regards,
Hari
India

"Jon Peltier" wrote in message
...
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 wrote:
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