Excel 2013 Charts and Graphs (eBook)

Use Excel 2013 to create breathtaking charts, graphs, and other data visualizations - and communicate even the most complex data more effectively than ever before!
InExcel 2013 Charts and Graphs, two world-class Excel experts show exactly how to make the most of Excel 2013's unprecedented visual features. Bill Jelen ('MrExcel') and Michael Alexander explain when and how to use each type of Excel chart, then walk through creating superb visuals and customizing them with themes, colors, and effects. Learn how to:
Design beautiful charts that communicate intuitively and accurately
Make the most of Excel 2013's new Recommended Charts feature
Use themes, colors, metallic effects, shadows, transparency, and more
Build effective business flowcharts with IGX
Craft charts that illuminate trends, differences, and relationships
Create effective stock analysis charts
Use Excel's flexible PivotCharts
Present geographical data on maps
Integrate product visuals into your charts
Make the most of Sparklines and other in-cell visualizations
Incorporate images and shapes with SmartArt
Export charts for use outside of Excel
Generate dynamic, customized charts automatically with Excel VBA
Even assess the truth of Excel charts — and recognize when you're being lied to!
This guide is part of the MrExcel's Library series, edited by Bill Jelen, renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com.

---

Use Excel 2013's radically revamped charting and graphing tools to communicate more clearly, powerfully, and quickly... so you drive your message home, and get the decisions and actions you're looking for! This book reveals data visualization techniques you won't find anywhere else and shows you how to use Excel 2013 to create designer-quality charts and graphs that stand out from the crowd. It will help you make the most of new features ranging from Power View to Recommended Charts, and instantly share your insights with anyone, anywhere-even on the Web and social networks. Learning advanced Excel techniques has never been easier. You'll find simple, step-by-step instructions, real-world examples and case studies, and more than a dozen YouTube videos, straight from MrExcel! * Create stunning data visualizations instantly with Excel 2013's new Recommended Charts * Use charts to instantly reveal trends, differences, and relationships * Map your data with Excel 2013, MapPoint, and the new GeoFlow add-in * Quickly generate combo charts that once required complex, frustrating procedures * Use sparklines to imbue worksheets with more context and insight * Highlight and clarify the meaning of data with DataBars, color scales, icon sets, and other conditional formatting tools * Post charts to Facebook, Twitter, or LinkedIn, directly from Excel * Build stock charts that help you make smarter investments * Solve "e;non-standard"e; problems such as noncontiguous data or custom data sequences * Generate new charts automatically with Excel VBA * Uncover visual tricks that people use to lie with Excel About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will: * Dramatically increase your productivity-saving you 50 hours a year or more * Present proven, creative strategies for solving real-world problems * Show you how to get great results, no matter how much data you have * Help you avoid critical mistakes that even experienced users make