Value Axis

[Chi]

Hi,

I have a line chart that presents two values - 1.13% and 1.18%. The chart
looks fine, but the Value Axis’s numbers, the vertical line or Y, is repeated.

Ex. The chart

Y: 1.11%, 1.11%, 1.12%, 1.13%, 1.13%......
X: Quarter 1, Quarter 2

Would you please tell me why the numbers on the vertical line is repeated
and how to fix the problem?
Thanks
Chi

 

[John Mansfield]

In the Format Axis dialog box for the Y Axis - tab called "Scale", check the
values for the minimum, maximum, and major axis units. By making adjustments
to the major axis value, you can eliminate the repeating numbers. Also check
the number of decimal places for the Y-Axis data. Another option for
eliminating the repeating numbers is to increase the amount of trailing
decimal places via the number formatting.