CF Graph rounding up the y axis

[maverik59]

HI I have successfully setup the graphs however i have some very odd y axis values such as 19.4 , 36.2 (On the bar on the right) Is it possible to get these to round up? Or permanenlty incremement by 50 for example?

Many Help Very Much Appreciated!
thanks in advance.

 

[maverik59]

Sorry I meant i'm using CF Chart

 

[cfuserinfl]

If you are using SQL Query to retrive date, you can use sql function Round().

try it

 

[maverik59]

The problem isn't with the values they are all whole numbers, its the labelling of the y axis has values such as 34.2 and things....

 

[cfuserinfl]

Try this thing in Query ..
Use round() function and us as function with it.
like

select round(Number) as Whole_Num from table

now in your Y axis values give this name as "Whole_Num"
and try this out. because here we using whole number

let me kwno what happend to it.

 

[maverik59]

I will give it ago nothing to loose, except i am already working with intergers. Its the labelling of the yaxis which for some reason shows values like 18.33 between each line scale, although the data is all interger values. I notice than when i'm creating a graph between 0-12,000y axis values it uses whole numbers between the scaling. However when i have data 0-200 it uses 2 decimal places, 0-300 1 decimal place! I wonder if its just possible to take the decimal place out of CFChart?

 

[cfuserinfl]

i got you..
try this
in
cfgraph tag make this this value "0"

gridLines = 0

let me know here

 

[maverik59]

Have been messing round with all those variables and i have it, I think its that - i've changed so many, back in a tick
Cheers

 

[maverik59]

nope nope nope, it was pure fluke i choose the data i did. oh well my search goes on....(I don't think there's a way though)

 

[cfuserinfl]

sorry I have tried make gridline =0 but its remove all grids..
But you can make gridline number such that its show you interger value.. Bcz i have graph and i have with 2 gridline its give me integer but with 4 gridline value its give me non interger value..
so play around and let me knwo how did u solve it..
thanks