Charts and Graphs for Microsoft Office Excel 2007

石头

作者：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 Charting
• Incorporating Drag & Drop and Dynamic Charts
• Creating Amazing Effects
• Using Charting Templates and Macros
• Mastering Glow, Shadow, Sparklines, Dashboards, and More
• Eliminating Chart Junk
• Structuring Spreadsheets with Business Diagrams, SmartArt Graphics, and Pivot Charts
• Develop your Charting expertise instantly with proven techniques

After 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 data
• 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
• Detect chart lies

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.


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.

justforonebook

1# 石头

感谢发布！

zhangli88

不为楼主这样的标题所吸引，也不是被帖子的内容所迷惑。我不是来抢沙发的，
也不是来打酱油的。我不是为楼主呐喊加油的，也不是对楼主进行围堵攻击的