Issue with Scale Interval on Y Axis of Chart

[rhuet]

I am trying to avoid decimal labels on the Y axis, since all my data consists of integer counts.  I was able to do that by setting the "Scale Interval" property to 1.  However, this has an unintended consequence:  when displaying data with a large number of counts, the chart does not display any intermediate scale values on my axis (for example, displays 0 at bottom and 1,200 at top, and nothing in between - see attached screenshot).

Any ideas how I can fix the decimal label problem without causing this other scaling problem?

[slim]

Hi rhuet,

Have you tried this ?
1. Click on '0 --> n' which is on the y axis of the chart
2. Then set data format property to 'Number'
3. On the property of 'number' format type, set 'No. of Decimal Places' to 0.


regards,
Slim

[rhuet]

That's exactly what I was missing.  Thanks, Slim!

[rhuet]

Looks like I spoke too soon.  Formatting the y-axis values to numbers with 0 decimals actually makes things worse.  When the data has low counts, the y-axis still displays fractional values, only now it rounds them up to the nearest integer.  So while before I had (0, .5, 1, 1.5, 2), now I have (0, 0, 1, 1, 2).  Unless you have any other suggestions, I think I will just live with the decimal y-axis labels when the counts are low.  This may just be a limitation of Cognos.