Brilliant Excel 2007 Solutions: Charts and Graphs

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 doesnt 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. Youll 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 cant 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 worl...

(Computer Bookshops Limited)