Microsoft Office Tutorials and References
In Depth Information
Chapter 7: Sparklines and Advanced Topics in Excel Charts
FIGURE 7.2 Insert Sparkline Icon Locations
FIGURE 7.3 Data for Six Months
FIGURE 7.4 The Steps to Create a Line Sparkline
line D2:I2. See Figure 7.4 for the steps to create the line. See Figure 7.5 for the
resulting lines for all projects when you drag the results down.
You can create the Column Sparklines and the Win/Loss Sparklines in columns K
and L. The results are shown in Figure 7.6. The Loss part on the last column is
colored in red.