Adding, Editing, and Removing a Chart Title


If you choose a layout option that includes a title, Excel will provide that for you. If your chart doesn't already have a title, you can add one by selecting any part of your chart, clicking the Layout tab under Chart Tools on the Ribbon, and then clicking Chart Title in the Labels group. On the menu that appears, choose either Centered Overlay Title or Above Chart. The former places the title within the plot area. The latter centers it above the plot area, reducing the size of the plot area to make room. If you need to adjust the position of the title, select it, and drag its bounding rectangle.

However you create the title, you might have to edit its default text. (Except when you're plotting a single data series with an adjacent cell containing text, Excel won't try to pluck a chart's title from the worksheet.) Figure 19-1 shows how your chart might look with a default title and legend. To enter a meaningful title on a chart like this, begin by selecting the default title. Excel responds by enclosing the title in a rectangle with corner handles. The simplest way to enter the text you want is by clicking the formula bar (above the worksheet) and typing. Alternatively, you can select the text you want to replace (Chart Title, or whatever else is currently there) and edit it.

image from book
Figure 19-1: If your chart layout includes a title, Excel will create one for you-but you'll probably have to edit the text.

Note 

To create a multiline title, press Ctrl+Enter at the end of each line.

Note 

To link a chart title to the contents of a worksheet cell, type a worksheet-qualified formula as the title text (that is, a formula that includes the name of the worksheet followed by an exclamation point). For example, suppose you want your chart's title to be the contents of cell A1 on Sheet1. You would type =sheetl!A1 as your title.

You might think you would be able to edit an existing chart title by selecting it and then editing the contents of the formula bar. Unfortunately, although Excel lets you type text this way, it does not display that text on the formula bar subsequently. To edit an existing title, return to the formula bar, and type your new title entirely. Or click twice-slowly-in the existing title. The first click selects the title object, and the second creates an insertion point, letting you edit in place.

To remove a title, select it, and press Delete. If you see an insertion point in the title when you select it, you can press Esc and then press Delete.



Microsoft Office Excel 2007 Inside Out
MicrosoftВ® Office ExcelВ® 2007 Inside Out (Inside Out (Microsoft))
ISBN: 073562321X
EAN: 2147483647
Year: 2004
Pages: 260

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net