Book description
Using Excel 2010, it's possible to create breathtaking charts, graphs, and other data visualizations - and communicate even the most complex data more effectively than ever before. In Charts and Graphs, one of the world's leading Excel experts show exactly how to make the most of Excel 2010's unprecedented visual features. Bill Jelen ("MrExcel") explains exactly when and how to use each type of Excel chart, then walks through creating superb visuals and customizing them with themes, colors, and effects. Jelen shows how to craft charts that illuminate trends, differences, and relationships; how to create stock analysis charts; how to use Excel's flexible PivotCharts; and even how to present data on maps with Microsoft MapPoint. You will discover how to make the most of Excel 2010's new Sparklines and other in-cell visualizations; how to incorporate additional images and shapes with SmartArt; how to export charts for use outside of Excel; and how to generate dynamic, customized charts automatically with Excel VBA. There's even a full chapter on assessing the truth of charts created in Excel - and recognizing when someone's trying to lie to you! This book is part of the new MrExcel Library series.
Everything Excel users need to know to communicate visually - from trend analysis to stock charting, geographical mapping to Excel 2010's new In-Cell Data Bars and Sparklines
From basic through leading-edge techniques - including the automatic generation of custom charts with VBA
Part of the brand-new MrExcel Library series, edited by Excel legend Bill Jelen
Table of contents
- Title Page
- Copyright Page
- Dedication
- Contents at a Glance
- Contents
- About the Author
- Acknowledgments
- Introduction: Using Excel 2010 to Create Charts
- 1. Introducing Charts in Excel 2010
- 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. Using Sparklines, Data Visualizations, and Other Nonchart Methods
- 10. Presenting Excel Data on a Map Using Microsoft MapPoint
- 11. Using SmartArt Graphics and Shapes
- 12. Exporting Charts for Use Outside of Excel
- 13. Using Excel VBA to Create Charts
- 14. Knowing When Someone Is Lying to You with a Chart
- A. Charting References
- Index
Product information
- Title: Charts and Graphs: Microsoft® Excel® 2010
- Author(s):
- Release date: September 2010
- Publisher(s): Que
- ISBN: None
You might also like
book
Create Dynamic Charts in Microsoft® Office Excel® 2007 and Beyond
Extend your Excel 2007 skills—and create more-powerful and compelling charts in less time. Guided by an …
book
Excel® 2013 Charts and Graphs
Use Excel 2013’s radically revamped charting and graphing tools to communicate more clearly, powerfully, and quickly… …
book
Microsoft® Excel® 2010 Formulas & Functions Inside Out
Conquer Microsoft Excel formulas and functions—from the inside out! You’re beyond the basics, so dive right …
book
Special Edition Using® Microsoft® Office Excel 2003
Does your life play out in a spreadsheet? Are numbers in columns and rows what make …