Microsoft Office Tutorials and References
In Depth Information
Inserting Unattached Text into a Chart
Select the chart.
In the Formula bar, type the text that you want to include in the chart.
To resize the new unattached text box, click and drag one of the text box’s selection
To move the unattached text box, click the border of the text box, and drag the text box
to a new location in the chart area.
To format the unattached text, select the text box and click the appropriate formatting
buttons on the Formatting toolbar; or double-click the border of the text box to open the
Format Text Box dialog box, use the options provided on the dialog box tabs, and then
click the OK button.
Alicia wants you to add the text “Vega Sales from the Last Fiscal Year” to the upper-
right corner of the plot area, and she wants the text to be ivory in color.
To add unattached text to the chart:
1. Click the column chart to select it, click in the Formula bar above the chart, type Vega
Sales from the Last Fiscal Year , and then press the Enter key. Excel places a text box
containing the new unattached text in the middle of the chart area. The text box is selected
so you can modify its appearance.
2. Click the Font Color list arrow on the Formatting toolbar, and then click the Ivory
square (sixth row, third column from the left) in the color palette.
3. Move the pointer over the edge of the unattached text box until the pointer changes to
drag the text box to the upper-right corner of the plot area, and then release the mouse
button. The text should now be placed in the upper-right corner of the plot.
You can double-click an unattached text box at any time to open the Format Text Box
dialog box, in which you can change the font format, alignment, and color. You can also
create a border around the text. Try this now by creating a yellow border.
To create a border for the text box:
1. Verify that the text box is still selected, and then double-click the border of the selected
text box to open the Format Text Box dialog box.
Trouble? If you double-clicked the text in the text box, the Format Text Box dialog box
did not open. Try double-clicking the border of the text box again.
2. Click the Colors and Lines tab.
3. Click the Color list box in the Line section, click the Ivory square (sixth row, third column)
in the color palette, and then click the OK button.
4. Click outside the chart to deselect it. Figure 4-25 shows the text box with the ivory border.