作者：Bill Jelen
出版日期：May 4, 2007
出版社：其它
页数：480
ISBN：ISBN-10: 0789736101 ISBN-13: 978-0789736109
文件格式：PDF



Product Description
It is easy to create a bad looking chart in Excel. This bookteaches you how to unlock the beautiful formatting options available tomake incredible looking charts. The first section will talk about howto decide which chart type to use. Subsequent chapters will walkthrough each chart type, how to create them, how to utilize them, andspecial options available for each chart. The book discusses themes,colors, creating metallic charts, shadows, transparency, etc. The bookalso handles anything graphical in Excel. It will show the new In-CellData Bar charts available in Excel 2007. A section will talk aboutcreating business flowcharts with IGX Graphics and how to displayproduct pictures in Excel, and a section on VBA will cover creating100’s of charts using the macro language.
“More than a how-to and reference, thisbook also provides the why-tos and when-tos, with serious considerationgiven to layout best practices and design possibilities–a verywell-rounded resource.”
–Kathy Villella, CEO, PowerFrameworks.com
Implementing 1-Click ChartingIncorporating Drag & Drop and Dynamic ChartsCreating Amazing EffectsUsing Charting Templates and MacrosMastering Glow, Shadow, Sparklines, Dashboards, and MoreEliminating Chart JunkStructuring Spreadsheets with Business Diagrams, SmartArt Graphics, and Pivot ChartsDevelop your Charting expertise instantly with proven techniquesAfter 15 years with no updates to the Excelcharting engine, Microsoft has provided a complete rewrite of the chartrendering engine in Excel 2007. However, no amount of soft glow orglass bevel effects will help you communicate your point if you use thewrong chart type. This book helps you choose the right charting typeand shows you how to make it look great.

This book shows you how to coax Excel tocreate many charts you might not have believed were possible. You’lllearn techniques that allow you to ditch the Microsoft defaults andactually create charts that communicate your point. You’ll learn whythe Excel stock charts are so restrictive and how you can easily turnany line chart into a stock chart–without any limitations. You’ll alsolearn how to add invisible series to make columns float in midair.Learn how to create charts right in Excel cells using the new Excel2007 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.
Master effective visual display of dataChoose the right chart type to convey your messageLearn time-saving workaroundsCreate charts that most people think you can’t create with ExcelUnderstand what a Radar chart is and when you might use itSummarize a million rows of data in a single pivot table chartPresent data graphically without chartsEmploy SmartArt graphics to show process or relationship chartsUtilize VBA to create chartsPut your data on a mapExport your charts to the web or PowerPointDetect chart liesABOUT THE AUTHOR
Bill Jelen is MrExcel! He isprincipal behind the leading Excel website, MrExcel.com. He honed hisExcel wizardry during his 12-year tenure as a financial analyst for afastgrowing public computer firm. Armed with only a spreadsheet, helearned how to turn thousands of rows of transactional data intomeaningful summaries in record time. He is an accomplished author ofbooks on Excel and is a regular guest on The Lab on TechTVCanada. You can find Bill at your local accounting group chaptermeeting entertaining audiences with his humorous and informative PowerExcel seminar. His website hosts more than 12 million page viewsannually.


Introduction
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 Show Relationships
6 Creating Stock Analysis Charts
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
Appendix A: Charting References
Index
About the Author
Bill Jelen is MrExcel! He isprincipal behind the leading Excel website, MrExcel.com. He honed hisExcel wizardry during his 12-year tenure as a financial analyst for afastgrowing public computer firm. Armed with only a spreadsheet, helearned how to turn thousands of rows of transactional data intomeaningful summaries in record time. He is an accomplished author ofbooks on Excel and is a regular guest on The Lab on TechTVCanada. You can find Bill at your local accounting group chaptermeeting entertaining audiences with his humorous and informative PowerExcel seminar. His website hosts more than 12 million page viewsannually.