Change Axis Options

1. Click anywhere on the chart that you want to modify.
2. Choose Chart Tools Layout => Labels => Axis Titles.
3. Select Primary Horizontal Axis Title or Primary Vertical Axis Title.
4. Choose an Axis title location. For the Horizontal axis, your choice is only Below the Axis (or None). For the Vertical axis, you have the option to rotate the title, run it vertically along the axis, or run it horizontally. We don't recommend the horizontal option because it takes up a great amount of chart space. Both a Vertical and a Horizontal Axis title.
   
   
   
   
   
   
5. Highlight the axis text and replace it with your desired text.
6. Choose Chart Tools Layout => Axes. Two options are available:
   
   Axes:
   Choose this option to change the way Excel displays either the horizontal or vertical axis. You can choose not to display an axis or you can change the value representation along the vertical axis. Click the More option to change choices such as axis-number formatting.
   
   
   
   
   
   Gridlines:
   Choose this option to change the way the gridlines display along the chart background. You can add, change, or remove horizontal or vertical gridlines. You can also select More Options to modify the gridline color.