About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store



Click here to order the book!

  “More than a how-to and reference, this book also provides
the why-tos and when-tos, with serious consideration given
to layout best practices and design possibilities–a very well-rounded resource.”

     -Kathy Villella, CEO,

Charts and Graphs for Microsoft Office Excel 2007

Turn Data into Meaningful, Informational Charts

After 15 years with no updates to the Excel charting engine, Microsoft has provided a complete rewrite of the chart rendering engine in Excel 2007. Charts can convey much more than numbers alone can because charts present data in a visual way that makes it easier to see the meaning behind the numbers. With the new charting capabilities in Microsoft Office Excel 2007, it's easier than ever to turn raw data into meaningful information. However, no amount of soft glow or glass bevel effects will help you communicate your data if you use the wrong chart type. This book helps you choose the right charting type!

Learn how to coax Excel to create many charts you might not have believed were possible!

This book will walk through each chart type, how to create them, how to utilize them, and special options available for each chart. It discusses themes, colors, creating metallic charts, shadows, transparency, etc. You'll learn techniques that allow you to ditch the Microsoft defaults and actually create charts that communicate your point.

You will also learn why the Excel stock charts are so restrictive and how you can easily turn any line chart into a stock chart - without any limitations. Find out how to add invisible series to make columns float in midair. This book shows you how to create charts right in Excel cells using the new Excel 2007 data bars - or even the decades-old REPT function!

Click here to order the book!

Design Charts Like the Pros!

Throughout the book, case studies take a look at charts designed outside of Excel. The book then takes you through the (usually non-intuitive) steps required to replicate the chart in Excel.

These case studies range from charts created by the McKinsey chart guru Gene Zelazny to charts created by Alfred E. Neuman. You can decide if Kyle Fletcher went too far in his chart comparing John Denver’s record sales before and after the airplane crash. See new uses for Radar Charts. Create Edward Tufte – style sparklines. Replicate the difficult charts used by Professor Charles H. Franklin when creating his Political Arithmetik blog.

About the Author

Bill Jelen is MrExcel! He is principal behind the leading Excel website, He learned about the graphical display of information during a 12-year tenure as a financial analyst for a fast growing public computer firm. He is an accomplished author of books on Excel and is a regular guest on “The Lab with Leo Laporte” on TechTV Canada. As an Excel consultant, he has written Excel VBA solutions for hundreds of clients around the English-speaking world. His website hosts over 12 million page views annually.

Click here to order the book!

In no time, this book will have you creating charts that wow your audience and effectively communicate your message.

Table of Contents

1. Introducing Charts in Excel 2007
2. Customizing Charts
3. Creating Charts That Show Trends
4. Creating Charts That Show Differences
5. Creating Charts That Relationships
6. Creating Stock Analysis Chart
7. Advanced Chart Techniques
8. Creating and Using Pivot Charts
9. Presenting Data Visually Without Charts
10. Presenting Your Excel Data on a Map Using Microsoft MapPoint
11. Using SmartArt Graphics and Shapes
12. Exporting Your Charts for Use Outside of Excel
13. Using Excel VBA to Create Charts
14. Knowing When Someone Is Lying to You with a Chart
A. Charting References

Click here to order the book!

"Develop your Charting expertise instantly with proven techniques"

Product Details
Paperback: 480 Pages ; Dimensions (in inches): 9 x 6.9 x 0.8 inches
Publisher: QUE; ISBN 978-0789736109 (April 2007)
Price: $39.95

Click here to order the book!


Excel is a registered trademark of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

All contents Copyright 1998-2008 by MrExcel Consulting.