| It is easy to create a bad looking chart in Excel. This book teaches
the reader how to unlock the beautiful formatting options available to
make incredible looking charts. The first section will talk about how
to decide which chart type to use. Subsequent chapters will walk
through each chart type, how to create them, how to utilize them, and
special options available for each chart. The book discusses themes,
colors, creating metallic charts, shadows, transparency, etc. The book
also handles anything graphical in Excel. We will show the new In-Cell
Data Bar charts available in Excel 2007. A section will talk about
creating business flowcharts with IGX Graphics and how to display
product pictures in Excel, and a section on VBA will cover creating
100's of charts using the macro language. Introduction . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . .1 1 Introducing Charts in Excel 2007 . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . 7 2
Customizing Charts . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . . . . . .37 3 Creating Charts That
Show Trends . . . . . . . . . . . . . . . . . . . . . . . . . . . .
81 4 Creating Charts That Show Differences . . . . . . .
. . . . . . . . . . . . . . . 121 5 Creating Charts That
Show Relationships . . . . . . . . . . . . . . . . . . . .
147 6 Creating Stock Analysis Charts . . . . . . . . . .
. . . . . . . . . . . . . . . . . . . 187 7 Advanced
Chart Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . 223 8 Creating and Using Pivot Charts . . . . .
. . . . . . . . . . . . . . . . . . . . . . . 267 9
Presenting Data Visually Without Charts . . . . . . . . . . . . .
. . . . . . . . 281 10 Presenting Your Excel Data on a
Map Using Microsoft MapPoint . 307 11 Using SmartArt
Graphics and Shapes . . . . . . . . . . . . . . . . . . . . . . . .
317 12 Exporting Your Charts for Use Outside of Excel . .
. . . . . . . . . . . . . . 347 13 Using Excel VBA to
Create Charts . . . . . . . . . . . . . . . . . . . . . . . . . . .
357 14 Knowing When Someone Is Lying to You with a Chart
. . . . . . . . . 423 Appendix A: Charting References . . . . .
. . . . . . . . . . . . . . . . . . . . . . 431 Index . . . . .
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. . . . . . . . . . . 439 |