Limit values on Y-Axis

[#1]

I need to limit the number of values that are displayed on my y-axis to 10. Right now I am showing too many values.  How do I limit the number?  I know I have to create a formula in Static Step but I don't know what that formula would be.

Thanks.

[swuehl]

If you know that your range of values is always like that, you can just input a fixed, magic number, no need for a complex expression, mayne try just inputting

500000000

as static step.

[shree909]

Hi go the chart properties and there u find the option axes

chart-->properties-->axes--scale

there u have static min, static max and step size there u provide the values

the the axes would be static..

so static max =10

static min=0

step size =1

hope this helps

[#4]

The Y-axis changes based on the filters that are chosen so simply entering 500000 in the Static Step will not work. 

[shree909]

i think u need to make both the x and y axis static  then no matter the values get changes but the axis values will be same..

[#6]

I would however the y-axis could be Thousands, Millions or even Billions of $

[shree909]

i think you can convert into either billions or millions  and show the result.

[#8]

Could you please attach your application?

[#9]

That is so awesome.  Never saw that before.