Skip to Content
0
Former Member
Sep 18, 2008 at 10:01 PM

Chart options: Y axis scale

584 Views

Hi,

I created a bar chart for a report that simly displays the count for each distinct value of a field. I would want the Y scale (which displays the count) to only present integer values (its a count, so it's obvious there can't be any non-integer values). Currently it's set to auto select the range and the number of divisions, for which the range it's ok but the divisions don't always come out as all integers. From what I can see, the only way to do this would be to set the min to 0, max to the max count on the report (which is normaly what the auto range does), and the number of divisions as the max count minus one. I don't really see any other way. Apparently there's no way to do this dynamically (like in a formula), and I don't think I can use static range values. Is there any way to do this? I just want to confirm what I know and see if there is any other way to do it.

Also, this is probably not the forum to post this, but just in case, is there any way to do this programatically in code without needing extra libraries or extra tools?

Thanks,

Diego