How do I change the maximum number of ticks on a graph in Excel 2007

I have a lab report due tomorrow and I am supposed to plot a data set given to me by the professor. The biology laboratory guidelines tell me to have no more than 5 tick marks on the graphs vertical axis. However the data plot, when I auto-create graph in Excel, is making a vertical axis with 8 ticks. How do I change the maximum number of ticks on the graph?

Note: I have tried changing the scale of the graph but that has left me with the same problem of too many major ticks on the graph.

I am a fairly inexperienced Excel user so any help as quickly as possible would be greatly appreciated.

1

1 Answer

1. Right-click on the axis whose tick marks you want to change. Excel displays a Context menu for the axis.
2. Choose Format Axis from the Context menu. (If there is no Format Axischoice, then you did not right-click on an axis in step 1). Excel displays the Format Axis dialog box.
3. Make sure the Axis Options tab is selected.
4. To the right of Major Unit, clickFixed and specify a multiple at which you want the major tick marks to appear. (for instance 2)
5. To the right of Minor Unit, clickFixed and specify a multiple at which you want the minor tick marks to appear. (This step is optional)
6. Click on OK.

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy