Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what is the use of static min,static max in axes tab in chart properties??
This is to set the static values that you are going to see in the axes no matter what value your expression takes.
For for instance if you are making a Sum(sales) where sum(Sales) has a maximun value of 100, for differente regions, you'll see a 100 in the X axes.
But if you choose a region with sum(Sales) = 50, the chart will be updated showing you number 50 in the X axe.
If yuo put a min of 0 and a max of 100, you will always see a 100 as the maximun value of the X axe even if you choose a region with sales less than 100
if you want to adjust fixed values distance on Axis , in that case you case you static min and static max.
you can fix min max and steps and chart will show values in between min and max and the dfference between 2 margin can be denoteed by step
suppose
min-0
max-10
step 1
it will display
01 2 3 4 5 6 7 8 9 10
and bar or points will be on one 0.....10
hope this helps