Microsoft Excel is more than a simple spreadsheet application; it also allow users to create complex calculations and organize data efficiently through the use of pivot tables, functions and graphs. A graph, also referred to as a chart in Excel, allows users to communicate not only data, but also the deeper meanings and implications that data can suggest. Graphical data is much easier for personnel outside of an accounting department to understand. Here's how to add titles to graphs in Excel in order to present the most accurate and complete depiction of a scenario.

Steps

  1. 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
    Notice several additions to the main toolbar when the graph is selected: Design, Layout and Format. These options are under a new header entitled "Chart Tools."
    Advertisement
  3. 3
    Select the Layout tab in the main toolbar. The Labels section of this tab holds the commands for working with titles and labels.
  4. 4
    Choose "Chart Title."
    • "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.
  5. 5
    Move your mouse and click inside the generic chart title to change the name of the chart to something more descriptive.
  6. 6
    Click "Chart title" on the toolbar again and select "More title options" at the bottom of the drop-down menu.
    • 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.
  7. 7
    Change the font and character spacing of your graph title by right-clicking on the title.
    • 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.
  8. 8
    Click Axis Titles to add these elements to your chart in Excel.
    • 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.
  9. Advertisement

You Might Also Like

Add Links in Excel4 Easy Ways to Add Links in Microsoft Excel
Add a Footer in ExcelAdd a Footer in Excel
Convert Excel to PDFConvert Excel to PDF
Make a Spreadsheet in ExcelMake a Spreadsheet in Excel
Unprotect an Excel SheetUnprotect an Excel Sheet
Create a Mortgage Calculator With Microsoft ExcelCreate a Mortgage Calculator With Microsoft Excel
Create a Graph in ExcelCreate a Graph in Excel
Create a Timeline in ExcelHow to Create a Timeline in Excel: SmartArt, Templates, and More
Change from Lowercase to Uppercase in ExcelChange from Lowercase to Uppercase in Excel
Video Player is loading.
Current Time 0:00
Duration -:-
Loaded: 0%
Stream Type LIVE
Remaining Time -:-
 
1x
Unhide Rows in Excel
Insert Pictures in Excel That Automatically Size to Fit CellsInsert Pictures in Excel That Automatically Size to Fit Cells
Convert Excel to Word3 Easy Ways to Convert Microsoft Excel Data to Word
Use ExcelNew to Excel? Here's Super Easy Tricks to Get You Started
Merge Cells in ExcelHow to Merge Cells in Microsoft Excel: A Quick Guide
Advertisement

About This Article

wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, volunteer authors worked to edit and improve it over time. This article has been viewed 205,803 times.
How helpful is this?
Co-authors: 7
Updated: March 5, 2020
Views: 205,803
Categories: Microsoft Excel
Advertisement