This book shows you how to coax Excel to create many charts you might not have believed were possible. You ll learn techniques that allow you to ditch the Microsoft defaults and actually create charts that communicate your point. You ll also learn how to add invisible series to make columns float in midair. Learn how to create charts right in Excel cells using the new Excel 2007 data bars or even the decades-old REPT function! Table Of ContentsIntroducing Charts in Excel 2007 Customizing Charts Creating Charts That Show Trends Creating Charts That Show Differences Creating Charts That Show Relationships Creating Stock Analysis Charts Advanced Chart Techniques Creating and Using Pivot Charts Presenting Data Visually Without Charts Presenting Your Excel Data on a Map Using Microsoft MapPoint Using SmartArt Graphics and Shapes Exporting Your Charts for Use Outside of Excel Using Excel VBA to Create Charts Knowing When Someone Is Lying to You with a ChartSalient FeaturesThis title was created for those who use specific features and functions, like charts and graphs in Excel This book covers anything and everything graphical in Excel from how to choose the correct chart to displaying product pictures; even covers VBA macros Bill Jelen and Michael Alexander have an experience base that would be difficult to replicate in any other team