Microsoft Office Tutorials and References
In Depth Information
Adding Great-Looking Graphics
Telling all with a text box
Text boxes, as their name implies, are boxes in which you can add
commentary or explanatory text to the charts you create in Excel. They’re like Excel
comments (see Chapter 6) that you add to worksheet cells except that you
have to add the arrow if you want the text box to point to something in the
chart.
In Figure 10-8, you see a clustered column chart for the MGE (Mother Goose
Enterprises) 2013 First Quarter Sales. I added a text box with an arrow that
points out how extraordinary the sales were for the Hickory, Dickory, Doc
Clock Shops in this quarter and formatted the values on the y-axis with the
Currency number format with zero decimal places.
Adding and formatting a text box
To add a text box like the one shown in Figure 10-8 to the chart when a chart
is selected, select the Format tab under the Chart Tools contextual tab. Then,
click the Insert Shapes drop-down button to open its palette where you select
the Text Box button (the very first button in the Basic Shapes section).
Figure 10-8:
Clustered
column
chart, with
added text
box and
formatted
y-axis
values.
Search JabSto ::




Custom Search