Using Excel 2010 it's possible to create breathtaking charts graphs & other data visualizations
- & communicate even the most complex data more effectively than ever before. In Charts & 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 (Mr Excel") explains exactly when & how to use each type of Excel chart then walks through creating superb visuals & customizing them with themes colors & effects. Jelen shows how to craft charts that illuminate trends differences & relationships; how to create stock analysis charts; how to use Excel's flexible Pivot Charts; & even how to present data on maps with Microsoft Map Point. You will discover how to make the most of Excel 2010's new Sparklines & other in-cell visualizations; how to incorporate additional images & shapes with Smart Art; how to export charts for use outside of Excel; & 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
- & recognizing when someone's trying to lie to you! This book is part of the new Mr Excel 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 & Sparklines * From basic through leading-edge techniques
- including the automatic generation of custom charts with VBA * Part of the br&-new Mr Excel Library series edited by Excel legend Bill Jelen"