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.

NEW	Excel 2007 still hasn't introduced any new chart types, but charts are easier to create, and they most definitely look much better. Figure 2-22 shows an Excel 2007 chart that uses some of the new formatting options.

Figure 2-22: Excel 2007 charts have improved in the looks department.

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.

Excel offers extensive chart customization options, and over the years , quite a few chartmaking tricks have made the rounds. These tricks enable you to create charts that you might think are impossible .