Charts

Excel is perhaps the most commonly used application in the world for creating charts. As I mention earlier in this chapter, you can store charts on a chart sheet or float them on a worksheet. You can also create pivot charts. A pivot chart is linked to a pivot table, and you can view various graphical summaries of your data by using the same techniques used in a pivot table.

A new feature in Excel 2010 is Sparkline charts. These small charts fit inside a cell. This type of chart is completely separate from Excel's standard chart feature. Figure 2-22 shows a worksheet with some Sparkline charts added.

FIGURE 2-22: Sparkline charts in a worksheet.