I have a bar graph, for the intervals for y axis i have used the expression =Round(CountRows()/5) , its working fine for large no. of data however if there is only single data , the intervals will be 0,0.2,0.4,0.6,0.8,1,1.2 ......... i want it to be a whole number instead of the floating point numbers thank you

Hi There thanks for your posting. can you please try =ceiling((CountRows()/5) ) =ceiling((CountRows()/5) ) Many thanks Syed