reactor

Resizing a Chart Title in Excel 2007:-

When you click a chart title to select it, a bounding box with four resizing handles appears. At least they look like resizing handles; actually, they are not. You do not have explicit control to resize the title. It feels like you should be able to stretch the title horizontally or vertically, as if it was a text box, but you cannot. The only real control you have to make a text box taller is by inserting carriage returns in the title, but you can only type carriage returns when you are in Text Edit mode.

The first click on a title selects the title object. A solid bounding box appears around the title. At this point, you can use most of the formatting commands on the Home ribbon to format the title. You click the Increase/Decrease Font Size buttons to change the font of all of the characters. Excel automatically resizes the bounding box around the title. If you do not explicitly have carriage returns in the title where you want the lines to be broken, you are likely to experience frustration at this point.

When you have the solid bounding box around the title, you could carefully right-click the bounding box and choose Edit Text. However, simply left-clicking a second time inside the bounding box also puts the title in Text Edit mode, as indicated by a dashed line in the bounding box. In Text Edit mode, you can select specific characters in the title and then move the mouse pointer up and to the right to access the mini toolbar and the formatting commands available there. You can edit specific characters within the title in order to create a larger title and a smaller subtitle, as shown in the Figure (given below).



(By selecting characters in Text Edit mode, you can create a title/subtitle effect.)

You cannot move the title when you are in Text Edit mode. To exit Text Edit mode, you right-click the title and choose Exit Edit Text or simply left-click the bounding box around the title. When the bounding box is solid, you can click anywhere on the border except the resizing handles and drag to reposition the title.