Chart Value Axis & Gridlines Question

[rebeto13]

Hi, I'm trying to set up a chart in which the values on the axis are displayed not with every gridline. In other words, lets say the gridlines are every 5 units, but I want the values on the axis to be every 10 units. Is this possible?

Thanks

 

[Datsmart]

Right click your axis on the chart.
Choose Fomat Axis
Uncheck the Auto box for "Major Units"
Type 10 in the value box
Click OK.