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?
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
That's exactly what I was missing. Thanks, Slim!
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.