How to Add Titles to Graphs in Excel

Step-by-Step Guide

1. 1

   Step 1: Click on the chart that needs a graph title in order to select it.

   A currently selected graph will have a shaded outline.
2. 2

   Step 2: Notice several additions to the main toolbar when the graph is selected: Design

   These options are under a new header entitled "Chart Tools."
   
   The Labels section of this tab holds the commands for working with titles and labels. , "Centered overlay title" will place a tiled object containing a generic title on the graph that will not resize it. "Above chart" will resize the chart and make room for a centered generic title above the graphical image. ,, Here you can add other elements such as a border, fill color or 3-D format to your title.
   
   You can also add additional rules to the alignment of your title to manipulate the vertical alignment, text direction and custom angle. , You can change the font style, size and color of your title.
   
   You can also add many different effects like strike-through, subscript, superscript and small caps. , The Primary Horizontal Axis Title option places that title below the horizontal axis.
   
   The Primary Vertical Axis Title menu includes several options for the display of the vertical axis title.
3. 3

   Step 3: Layout and Format.

4. 4

   Step 4: Select the Layout tab in the main toolbar.

5. 5

   Step 5: Choose "Chart Title."

6. 6

   Step 6: Move your mouse and click inside the generic chart title to change the name of the chart to something more descriptive.

7. 7

   Step 7: Click "Chart title" on the toolbar again and select "More title options" at the bottom of the drop-down menu.

8. 8

   Step 8: Change the font and character spacing of your graph title by right-clicking on the title.

9. 9

   Step 9: Click Axis Titles to add these elements to your chart in Excel.

Detailed Guide

About the Author