y axis question

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Dave said:
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
Click to expand...

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.
 
Back
Top