y axis question

[Guest]

Hello.

I have a remedial charting question. When I generate charts with small
values in the y axis (<3 for example), the numbers along the y axis go into
fractions (.5, .25, .75, etc...).

How can I force the numbers on the y axis to stay in whole numbers?

Thanks in advance -- Dave

 

[Rick Brandt]

Hello.

I have a remedial charting question. When I generate charts with
small values in the y axis (<3 for example), the numbers along the y
axis go into fractions (.5, .25, .75, etc...).

How can I force the numbers on the y axis to stay in whole numbers?

Thanks in advance -- Dave

Double-click the chart while in design view to brign up the chart design tools.
Once in there you can right click on the axis and choose "Format Axis". I think
that setting the "Minor Unit" to an integer will prevent fractions in the scale.