Overview

"Using Excel 2010, it's possible to create breathtaking charts, graphs, and other data visualisations - 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 customising them with themes, colours, 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 visualisations; how to incorporate additional images and shapes with SmartArt; how to export charts for use outside of Excel; and how to generate dynamic, customised charts automatically with Excel VBA."

Full Product Details

Author:   Bill Jelen
Publisher:   Pearson Education (US)
Imprint:   Que Corporation,U.S.
Dimensions:   Width: 18.10cm , Height: 2.40cm , Length: 22.90cm
Weight:   0.742kg
ISBN:  

9780789743121

ISBN 10:   0789743124
Pages:   480
Publication Date:   07 October 2010
Audience:   Professional and scholarly ,  Professional & Vocational
Replaced By:   9780789748621
Format:   Paperback
Publisher's Status:   Active
Availability:   In Print  
This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us.

Table of Contents

Introduction 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 Charting Techniques 8. Creating and Using Pivot Charts 9. Using Sparklines, DataBars and Other In-Cell Visualizations 10. Presenting Your 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

Reviews

Author Information

"Bill Jelen, known worldwide as MrExcel, presents live Excel seminars to accountants throughout the U.S. His 20 books on Microsoft Excel include Special Edition Using Excel 2007, Pivot Table Data Crunching, and VBA and Macros for Microsoft Excel. Honored as a Microsoft MVP for Excel, he has produced 500 episodes of his ""Learn Excel from MrExcel"" video podcast. Michael Alexander, is a Microsoft Certified Application Developer (MCAD), Senior Program Manager for a top Texas technology firm, and principal of DataPigTechnologies, a developer of Excel tutorials. He is author of several books on data analysis with Access and Excel."

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions