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.