- On Chart, choose Format Chart--X Axis.
Chart--Format Chart--X Axis appears.
- Choose Gridlines.
Gridlines appears.
- Specify the type of axis:
- To make the axis a category axis, select Is Category Axis.
- To make the axis a value axis, deselect Is Category Axis.
Close Gridlines.
- Choose Finish.