Microsoft Office Tutorials and References
In Depth Information
Chart Tricks for the Daring and Heroic
To annotate a chart, select a callout shape, enter text in the callout shape,
and connect the shape to part of your chart. Follow these steps to annotate
1. Select your chart and go to the (Chart Tools) Format tab.
2. Open the Shapes gallery, scroll to the Callouts section of the drop-down
list, and choose a callout.
Depending on the size of your screen, you may have to click the Insert
button to get to the Shapes button.
3. Drag on the page or slide to draw the callout shape.
Chapter 4 of this mini-book explains drawing shapes in gory detail.
4. Type the annotation inside the callout shape.
5. Resize the callout shape as necessary to make it fit with the chart.
6. Drag the yellow square on the callout shape to attach the callout to
You probably have to do some interior decorating to make the callout
color fit with the chart. Chapter 4 of this mini-book explains how to
change an object’s color.
Displaying the raw data alongside the chart
Showing the worksheet data used to produce a chart is sort of like showing
the cops your I.D. It proves you’re the real thing. It makes your chart more
authentic. If yours is a simple pie chart or other chart that wasn’t generated
with a large amount of raw data, you can display the data alongside your
chart in a data table. Anyone who sees the table knows you’re not kidding or
fudging the numbers.
To place a table with the raw data below your chart, go to the (Chart Tools)
Design tab, open the Quick Layouts gallery, and select a layout that includes
a data table.
To format a data table, go to the (Chart Tools) Format tab, open the Chart
Element drop-down list, and choose Data Table. Then click the Format
Selection button. You see the Format Data Table task pane, where you can
fill the table with color and choose colors for the lines in the table.
Placing a trendline on a chart
Especially on column charts, a trendline can help viewers more clearly see
changes in data. Viewers can see, for example, that sales are going up or
down, income is rising or falling, or annual rainfall is increasing or
decreasing. Figure 1-10 shows an example of a trendline on a chart. In this case, the
trendline shows that the deer population in Sacramento County is rising.