Microsoft Office Tutorials and References
In Depth Information
More about Charts
FIGURE 7.5 Sparklines Results for all Projects
FIGURE 7.6 The Complete Example with the Line, Column, and the Win/Loss Sparklines
FIGURE 7.7 A Line and a Column Chart of Project 1 ’ s Data
FIGURE 7.8 Add Text to the Sparkline Cell
In essence the Sparklines are micro charts of similar conventional Excel charts. If
you, for example, take the data for Project 1 and create a line chart and a column
chart, you will be creating the Line and the Column Sparklines shown in Figure 7.7.
You will note that the cells containing the actual Sparklines are empty when you
look at the Formula Bar or when you edit the cells. You may take advantage of it and
add text or other contents to the cell. See Figure 7.8.
The Sparklines has a number of design and other options. I chose to display a
couple of design ideas as you can see in Figure 7.9.
MORE ABOUT CHARTS
Chapter 6 described how to create a variety of charts. In this section we will examine
a couple of charts and ideas that can make you understand your data better data and
make your presentations look much better. We will demonstrate how to use the
Surface Chart and how to animate charts.