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.

Prod u ct U sage by Age and Sen

4L M FMUltf it-»

1Mb

| 11»

—r-1

^ mi.

ll-W

7

w w m t^i im m V>hhjhwh«*WW who ust in

K

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

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.

4 PREV

NEXT

0 0

Post a comment