Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .11 Introducing Charts in Excel 2007 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72 Customizing Charts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .373 Creating Charts That Show Trends . . . . . . . . . . . . . . . . . . . . . . . . . . . . 814 Creating Charts That Show Differences . . . . . . . . . . . . . . . . . . . . . . 1215 Creating Charts That Show Relationships . . . . . . . . . . . . . . . . . . . . 1476 Creating Stock Analysis Charts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1877 Advanced Chart Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2238 Creating and Using Pivot Charts . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2679 Presenting Data Visually Without Charts . . . . . . . . . . . . . . . . . . . . . 28110 Presenting Your Excel Data on a Map Using Microsoft MapPoint . 30711 Using SmartArt Graphics and Shapes . . . . . . . . . . . . . . . . . . . . . . . . 31712 Exporting Your Charts for Use Outside of Excel . . . . . . . . . . . . . . . . 34713 Using Excel VBA to Create Charts . . . . . . . . . . . . . . . . . . . . . . . . . . . 35714 Knowing When Someone Is Lying to You with a Chart . . . . . . . . . 423Appendix A: Charting References . . . . . . . . . . . . . . . . . . . . . . . . . . . 431Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 439
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.
Bill Jelen is MrExcel! He is principal behind the leading Excel website, MrExcel.com. He honed his Excel wizardry during his 12-year tenure as a financial analyst for a fastgrowing public computer firm. Armed with only a spreadsheet, he learned how to turn thousands of rows of transactional data into meaningful summaries in record time. He is an accomplished author of books on Excel and is a regular guest on The Lab on TechTV Canada. You can find Bill at your local accounting group chapter meeting entertaining audiences with his humorous and informative Power Excel seminar. His website hosts more than 12 million page views annually.
![]() |
Ask a Question About this Product More... |
![]() |