Dear experts!

I know it is possible to control source data ranges from worksheet.

Is there a way to control y scaling (minimum, maximum) from worksheet too?

Thanks for answers,

Marko

Marko -

You need to use VBA to do this for you. Here is the necessary code:

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

If you want a ready-to-use solution, try Tushar Mehta's AutoChart Manager
add-in, available as a free download at http://www.tushar-mehta.com.


- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"Marko Pinteric" <(E-Mail Removed)> wrote in message
news:e1b6vp$q5b$(E-Mail Removed)...
> Dear experts!
>
> I know it is possible to control source data ranges from worksheet.
>
> Is there a way to control y scaling (minimum, maximum) from worksheet too?
>
> Thanks for answers,
>
> Marko
>

So VBA is the only way.

Thanks for the answer.

Marko

Jon Peltier wrote:
> Marko -
>
> You need to use VBA to do this for you. Here is the necessary code:
>
> http://peltiertech.com/Excel/Charts/...nkToSheet.html
>
> If you want a ready-to-use solution, try Tushar Mehta's AutoChart Manager
> add-in, available as a free download at http://www.tushar-mehta.com.
>
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services - Tutorials and Custom Solutions -
> http://PeltierTech.com/
> 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
> http://peltiertech.com/Excel/ExcelUserConf06.html
> _______
>
> "Marko Pinteric" <(E-Mail Removed)> wrote in message
> news:e1b6vp$q5b$(E-Mail Removed)...
>
>>Dear experts!
>>
>>I know it is possible to control source data ranges from worksheet.
>>
>>Is there a way to control y scaling (minimum, maximum) from worksheet too?
>>
>>Thanks for answers,
>>
>>Marko
>>
>
>
>

Well, no. I use a non-VBA worksheet function technique in some proprietary
workbooks. It's complex enough that I can't do it justice in a newsgroup
post, and I have not had time to generate a web page describing it.

Basically it requires calculating appropriate axis scale parameters (based
on the data or on user overrides), scaling the data from 0 to 1 (between the
calculated min and max), plotting the transformed data on a scale of 0 to 1,
hiding the regular chart axis, and creating a custom axis based on the
calculated parameters.

The custom axis part is shown here:

http://peltiertech.com/Excel/Charts/...tml#axisscales

Several of these links show the use of transformed data. For now you'll have
to come up with your own algorithms for axis scale parameters.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"Marko Pinteric" <(E-Mail Removed)> wrote in message
news:nco_f.1633$(E-Mail Removed)...
>
> So VBA is the only way.
>
> Thanks for the answer.
>
> Marko
>
> Jon Peltier wrote:
>> Marko -
>>
>> You need to use VBA to do this for you. Here is the necessary code:
>>
>> http://peltiertech.com/Excel/Charts/...nkToSheet.html
>>
>> If you want a ready-to-use solution, try Tushar Mehta's AutoChart Manager
>> add-in, available as a free download at http://www.tushar-mehta.com.
>>
>>
>> - Jon
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Peltier Technical Services - Tutorials and Custom Solutions -
>> http://PeltierTech.com/
>> 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
>> http://peltiertech.com/Excel/ExcelUserConf06.html
>> _______
>>
>> "Marko Pinteric" <(E-Mail Removed)> wrote in message
>> news:e1b6vp$q5b$(E-Mail Removed)...
>>
>>>Dear experts!
>>>
>>>I know it is possible to control source data ranges from worksheet.
>>>
>>>Is there a way to control y scaling (minimum, maximum) from worksheet
>>>too?
>>>
>>>Thanks for answers,
>>>
>>>Marko
>>>
>>
>>