How to change the maximum Range of a column graph depending on a maximumvalue in a Range of Values.
The problem is sometimes the values are as low as 1000
and sometimes the values are 50,000. When we set the Maximum scale to 50000 the columns are near to zero if the value is 500 or 1000.and the graph doesnt look good.
Can we change this scale depending on the values in a given Range.