Deleting the Title and Using a Text Box in Excel 2007:-


If you are frustrated that the title cannot be resized, you can delete the title and use a text box for the title instead. The title in the Figure (given below) is actually a text box. Note the eight resizing handles on the text box instead of the four resizing handles that appear around a title.



(Instead of a title, this chart uses a text box for additional flexibility.)

To create the text box shown in the above Figure, you follow these steps:

1. Delete the original title by choosing Chart Title, None from the Layout ribbon. Excel resizes the plot area to fill the space that the title formerly occupied.

2. Select the plot area by clicking some whitespace inside the plot area. Eight resizing handles now surround the plot area. Drag the top resizing handle down in order to make room for the title.

3. On the Insert ribbon, click the Text Box icon.

4. Click and drag inside the chart area to create a text box.

5. Click inside the text box and type a title. Press the Enter key to begin a new line. If you don’t press the Enter key, Excel word-wraps and begins a new line when text reaches the right end of the text box.

6. Select the characters in the text box that make up the main title and use either the mini toolbar or the tools on the Home ribbon to make the title 18 point, bold, and Times New Roman.

7. Select the remaining text that makes up the subtitle in the text box and use the tools on the Home ribbon to make the subtitle be 12 point, italics, Times New Roman.

Microsoft advertises that all text can easily be made into WordArt. However, when you use the WordArt drop-downs in a title, you are not allowed to use the Transform commands found under Text Effects on the Drawing Tools Format ribbon. When you use the WordArt menus on a text box, however, all the Transform commands are available. Look into the Figure (given below).



(Using a text box instead of a title allows more formatting options.)