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

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.

• 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.

• 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.

• 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: Blink Del.icio.us Digg
Furl Google Simpy Spurl Technorati Y! MyWeb