"Excel 2007 Chart Title: How to Create and Format it?"


The Excel 2007 chart title is text that typically appears above or overlapping the chart that indicates what the chart represents. It's one of the important elements in a chart.

The Excel 2007 Chart (also known as graph) is a visual representation of numeric values. Displaying data in a well-conceived chart can make your numbers more understandable.


To give the chart a title

  • Select the chart that you have created ( chart example ), if needed.
  • On the Chart Tools Layout tab, in the Labels group, click Chart Title icon and select one of the option from the drop-down list.

Excel 2007 Chart title

  • You will notice that the Chart Title text box inserted into the chart. Click to change the chart title (just type as you wish).


To format the Excel 2007 chart title

  • Right-click the chart title and choose Format Chart Title.
  • From the Format Chart Title dialog box displayed, select the category option and do the formation as needed.
  • Alternatively, you can click on the Chart Title icon and click the More Title Options to display the Format Chart Title dialog box.
  • The generally available categories are Fill, Border Color, Border Styles, Shadow, 3-D Format and Alignment.

Excel Format Chart Title

  • When finish, click Close.


Chart Axis

A chart axis title is text that defines the category or the unit of measurement on an axis. For a normal chart, you need to give a horizontal and vertical chart axes to make your chart more meaningful.


To give a chart axis title

  • Select the chart, if needed.
  • On the Chart Tools Layout tab, in the Labels group, click Axis Titles icon and select either Primary Horizontal Axis Title or Primary Vertical Axis Title to display a submenu that is specific to that axis.

Primary Horizontal Axis Title

  • For the horizontal axis title, the options are simple: either None or Title Below Axis.
  • For the vertical axis title, you can choose from the following options:
    Rotated Title: The title appears vertically along the vertical axis, with the letters rotated 90 degrees.

    Vertical Title: The title appears vertically along the vertical axis, but each letter remains unrotated, so that the letters are stacked one on top of the other.

    Horizontal Title: The title appears horizontally, like regular text, to the left of the vertical axis.

  • A text box appears. Click and type your own label to replace it.


Related Topics:

Guide to Creating a Chart from Data in a Excel 2007 Worksheet
Guide to Creating and Formatting the Excel 2007 Chart Legend
Step-by-step guide to Create a Pie Chart in Excel 2007?
How to Make a Histogram with Microsoft Excel 2007?



Can't find what you're looking for? Try Google Search!

Custom Search


Back to Top

You're viewing the Excel 2007 chart title info page, click here to go back to the Home Page

Add To Your Social Bookmarks: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Books:

Click on the image to view the details of the book.
Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007




XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.