Formatting an Axis Title in Excel 2007:-

Excel has three built-in options for the vertical axis. Figure (given below) shows these options: Rotated Title (top left), Vertical Title (bottom left), and Horizontal Title (bottom right). In many cases, the Rotated Title option looks the best. For a horizontal axis title, the only built-in option is to turn the title on or off.

All the formatting options available for the chart title also apply to the axis titles. You can use the mini toolbar, the Home ribbon, or the Format ribbon to change the font, color, fill, and effects for the axis title.



(The vertical axis title can be oriented in three ways, using the Axis Titles drop-down on the Layout tab.)