Microsoft Office Tutorials and References
In Depth Information
Using Sparklines
Deleting a chart
Charts may be nice to look at, but eventually you may want to delete them.
To delete a chart, follow these steps:
1. Click the chart you want to delete.
2. Press Delete.
You can also right-click a chart; then when the pop-up menu appears,
choose Cut.
Using Sparklines
Creating a chart can help you visualize your data, but sometimes a massive
chart with legends, titles, and X/Y-axis can seem like too much trouble for
just identifying trends in your data. For a much simpler tool, Excel offers
Sparklines.
Sparklines allow you to see, at a glance, the relationship between values
stored in multiple cells. Rather than look at a row or column of numbers to
determine if the values are increasing or decreasing over time, you can create
a Sparkline that condenses this information in a single cell that you can see at
a glance. Excel offers three types of Sparklines, as shown in Figure 10-10:
Line
Column
Win/Loss
Creating a Sparkline
To create and display a Sparkline in a spreadsheet, follow these steps:
1. Select the cells that contain the data you want to turn into a Sparkline.
2. Click the Insert tab.
3. Click on the Line, Column, or Win/Loss icon in the Sparklines group.
A Create Sparklines dialog box appears, as shown in Figure 10-11.
 
Search JabSto ::




Custom Search