Bibliographic record and links to related information available from the Library of Congress catalog.
Note: Contents data are machine generated based on pre-publication provided by the publisher. Contents may have variations from the printed book or be incomplete or contain other coding.
Table of Contents Introduction Chapter 1: Introducing Charts in Excel 2007 Chapter 2: Customizing Charts Chapter 3: Creating Charts that Show Trends Chapter 4: Creating Charts that Show Differences Chapter 5: Creating Charts that Show Relationships Chapter 6: Working with Advance Chart Types Chapter 7: Using Advanced Chart Techniques Chapter 8: Creating and Using Pivot Charts Chapter 9: Presenting Data Graphically Without Charts Chapter 10: Presenting Your Excel Data on a Map Using Microsoft MapPoint Chapter 11: Using SmartArt Graphics and Shapes Chapter 12: Exporting Your Charts Chapter 13: Using Excel VBA to Create Charts Chapter 14: Knowing When Someone is Lying to You With a Chart Appendix: Charting References (c)About the Author Bill Jelen, Excel MVP and MrExcel, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. His team provides custom Excel applications to clients around the world. You can see Bill as a regular guest on Call for Help with Leo Laporte in Australia, in Canada, and on Google Video. Bill produces a daily video podcast about Excel. He also enjoys taking his show on the road, doing a one- to four-hour power Excel seminar anywhere that a room full of accountants or Excellers will show up. ***End About the Author*** ************************************************************** ***Begin Dedication/Acknowledgments page: The Dedication and Acknowledgments should be on the same page.*** (c)Dedication ***Begin Dedication*** To Josh Jelen ***End Dedication*** (c)Acknowledgments I wish to thank Gene Zelazny of McKinsey & Company. Gene was generous with his time and feedback. He indirectly taught me a lot about charting over a decade ago, when I did a six-month stint on a McKinsey project team. Kathy Villella and Tom Bunzel also provided advice on presentations. Mike Alexander, my coauthor on the Pivot Table Data Crunching books, helped outline the table of contents for this book and provided many ideas for Chapter 7, "Using Advanced Chart Techniques." You can catch Mike and me on a cool DVD training series by Total Training. I enjoy the visual delight of every Edward Tufte book. I apologize in advance to E.T. for documenting all the chartjunk that Microsoft lets us add to Excel charts. Dick DeBartolo is the Daily Giz Whiz and has been writing for MAD Magazine for over 40 years, since he was 15. The pages of MAD were not where I expected to find inspiration for a charting book, but why not? John Marcinko is my son's friend who pointed me, in a random conversation, to the MAD charts. I was visiting Keith Bradbury's office in Toronto. Keith makes the completely awesome PDF-to-Excel utility at InvestInTech.com. Between parking the car and Keith's office, I saw the most amazing store, managed by David Michaelides. SWIPE is a bookstore dedicated to art and design. This is a beautiful store to browse, and if you go in and reveal that you work in Excel all day, they will sympathetically be very nice to you. In a clash of worlds, David has the original 1984 Mac way up above his cash register because it was the start of desktop publishing. I pointed out that the Mac was where Excel 1.0 got its start in 1985, so we had a common thread in our respective backgrounds. Stop by 477 Richmond Street West (two blocks west of Spadina) to take a look the next time you are in Toronto. Thanks to Leo Laporte and everyone else at TechTV in Toronto. By the time this book is out, production will have moved to Vancouver, so I offer my thanks to Matt Harris and everyone else at the Vancouver studio, even though I don't know who you are yet. Thanks to Dan Bricklin and Bob Frankston for inventing the computer spreadsheet. Thanks to Mitch Kapor for Lotus 1-2-3. Like everyone else who uses computers to make a living, I owe a debt of gratitude to these three pioneers. Thanks to Lora White, Tracy Syrstad, and Barb Jelen for keeping MrExcel running while I wrote. As always, thanks to the hundreds of people answering 30,000 Excel questions a year at the MrExcel message board. Thanks to Duane Aubin, Wei Jiang, Suat Ozgur, Nate Oliver, and Jake Hildebrand for their programming expertise. At Pearson, Loretta Yates is an awesome acquisitions editor. Thanks to Judi Taylor, Greg Wiegand, Michael Thurston, Laura Norman, and Lisa Jacobson-Brown at QUE. Jean Esposito was a great high school English teacher who used up many red pens marking my papers. Had Kitty Jarrett been around to be my copyeditor back then, there would have been no need for red ink at all. Thanks to my agent, William Brown. Juan Pablo Gonzalez is the best technical editor anyone could ever want. Finally, thanks to Josh Jelen, Zeke Jelen, and Mary Ellen Jelen. I wrote 2,500 pages in 2006[md]way too many to actually pay attention to anything important in my life. 2007 will be better. ***Begin Tell Us What You Think page*** (c)We Want to Hear from You! As the reader of this book, you are our most important critic and commentator. We value your opinion and want to know what we're doing right, what we could do better, what areas you'd like to see us publish in, and any other words of wisdom you're willing to pass our way. As an associate publisher for Que Publishing, I welcome your comments. You can email or write me directly to let me know what you did or didn't like about this book[md]as well as what we can do to make our books better. Please note that I cannot help you with technical problems related to the topic of this book. We do have a User Services group, however, where I will forward specific technical questions related to the book. When you write, please be sure to include this book?s title and author as well as your name, email address, and phone number. I will carefully review your comments and share them with the author and editors who worked on the book. Email: feedback@quepublishing.com Mail: Greg Wiegand Associate Publisher Que Publishing 800 East 96th Street Indianapolis, IN 46240 USA (c)Reader Services Visit our website and register this book at www.quepublishing.com/register for convenient access to any updates, downloads, or errata that might be available for this book.
Library of Congress Subject Headings for this publication:
Microsoft Excel (Computer file).
Business -- Computer programs.
Electronic spreadsheets.
Charts, diagrams, etc. -- Computer programs.