Thread: 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" <jonREMOVExlmvp@peltierCAPStech.com> wrote in message
news:ucwwBVBhFHA.2444@tk2msftngp13.phx.gbl...
> 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" <jonREMOVExlmvp@peltierCAPStech.com> wrote in message
> news:ucwwBVBhFHA.2444@tk2msftngp13.phx.gbl...
>
>>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" <jonREMOVExlmvp@peltierCAPStech.com> wrote in message
news:OcoamvhhFHA.320@TK2MSFTNGP09.phx.gbl...
> 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" <jonREMOVExlmvp@peltierCAPStech.com> wrote in message
>> news:ucwwBVBhFHA.2444@tk2msftngp13.phx.gbl...
>>
>>>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
>>
>>