Skip to Content
0
Former Member
May 14, 2008 at 10:04 AM

Decimals on y-axis for small whole numbers

310 Views

Post Author: jlw98r

CA Forum: Charts and Graphs

I have a stacked bar chart where the data for display on the y-axis is only ever whole numbers. If the maximum y-axis value is 5 or more the values on the axis are displayed normally as whole numbers. But if the number is lower than 5 the y-axis numbers are displayed as decimals (e.g. 0.5, 1, 1.5, 2 etc if the maximum is 4, or 0.4, 0.8, 1.2 etc if the maximum is 2), even though all the values are whole numbers. The number format is set to 1 in the Chart Expert and in Format Axis Labels (right click number on y-axis) the Category is set to Number and the Decimal Places are set to zero.

I have seen this problem reported on different forums but have not seen a working solution. Does anyone know if this is just a feature of Crystal XI, or if there is a workaround?

Thanks in advance.