Min and max for Axis-scale

[GVe]

I know, that I can alter the lower- and upperlimits of a scale in a graph by adding values to the minimum- en maximum-options for Scale.

Is it possible to make this more dynamically, for example to use a Name there?

 

[Hui]

GVe


Firstly, Welcome to the Chandoo.org Forums


Unfortunately, unless you resort to VBA the way your doing it is as good as it gets.

With VBA you can have full control over the Min, Max and Grid Spacing from cells or controls.


It is not that hard if your interested, you may want to upload a sample file

Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook

 

[GVe]

Hui,


thank you for your answer.

Now I know for sure, I do not have to search anymore!

I willl try to use my VBA-knowledge.