Axis

Hello Christopher,

My first question to you is:

What is the maximum value of the chart data?

Presumably it is less than 1600? Are you saying that the only numbers you want to see in the vertical axis is 0 and 1600 and not all the numbers inbetween? If this is the case, then click the Axes button, select the Primary Vertical Axis and then select More Primary Vertical Axis Options... In the Axis Options section make sure that you select the Fixed radio button for Maximum and enter 1600. Then for the Major Unit select the Fixed radio button and again enter 1600. Close the dialogue box and now you will see 0 - 1600 on the vertical axis of the chart.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer