Charts and Graphs: Microsoft Excel 2010

The first practical, hands-on guide to getting the most out of Excel 2010s jaw-dropping new charts, graphs, and other visual features! Everything Excel users need to know to communicate visually - from trend analysis to stock charting, geographical mapping to Excel 2010s 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. Using Excel 2010, its 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 worlds leading Excel experts show exactly how to make the most of Excel 2010s 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 Excels flexible PivotCharts; and even how to present data on maps with Microsoft MapPoint. Readers will discover how to make the most of Excel 2010s 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. Theres even a full chapter on assessing the truth of charts created in Excel - and recognizing when someones trying to lie to you! This book is part of the new MrExcel Library series.