From the Back Cover
Brilliant Excel 2007 Charts & Graphs
What you need to know and how to do it
Excel is one of the most powerful office and business productivity tools available – but do you know how to harness its full potential? Do you want to get a better understanding of its full capabilities and potential, and develop the Excel skills that you need to produce solutions to all of your business needs? Brilliant Excel Charts & Graphs will deliver increased office productivity and improved results by unleashing your inner Excel expert! This book is for the savvy Excel user who wants to understand and then use the advanced features of Excel but doesn’t want to dedicate their life to it.
Develop your Excel 2007 expertise instantly with proven techniques
After 15 years with no updates, Microsoft has complete rewritten the chart rendering engine in Excel 2007. However, no amount of soft glow or glass bevel effects will help you communicate your point if you use the wrong chart type. This book helps you choose the right charting type and shows you how to create many charts you that 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 learn why the Excel stock charts are so restricted and how you can easily turn any line chart into a stock chart--without any limitations. You'll also learn how to add invisible series to make columns float in midair, how to create charts right in Excel cells using the new Excel 2007 data bars - or even the decades - old REPT function!
In no time, this book will have you creating charts that wow your audience and effectively communicate your message.
Brilliant Excel 2007 Charts & Graphs will show you how to ….
- Master effective and visual data display
- Understand the new charting engine in Excel 2007
- Choose the right chart type to convey your message
- Learn time-saving workarounds
- Create charts that most people think you can’t create with Excel
- Understand what a Radar chart is and when you might use it
- Summarize a million rows of data in a single pivot table chart
- Present data graphically without charts
- Employ SmartArt graphics to show process or relationship charts
- Utilize VBA to create charts
- Put your data on a map
- Export your charts to the web or PowerPoint
Bill Jelen is Mr. Excel! He is principal behind the leading Excel website, MrExcel.com and a Microsoft MVP for Excel. He is an accomplished author of books on Excel , and 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 and his daily video podcast is regularly in the top tech podcasts in iTunes.
Visit us on the web at
About the Author
Bill Jelenis Mr. Excel! He is principal behind the leading Excel website, MrExcel.com and a Microsoft MVP for Excel. He is an accomplished author of books on Excel , and 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 and his daily video podcast is regularly in the top tech podcasts in iTunes.
Michael Alexanderis a Microsoft Certified Application Developer (MCAD) with over 13 years experience developing business solutions with Microsoft Office, VBA, and .Net. He currently heads an analytical services group for a $700-million company. In his spare time he runs a free tutorial site, www.datapigtechnologies.com, where he shares basic Access and Excel tips with intermediate users.