Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
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. |
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 .