Charts and Graphs

Więcej o książce

Using Excel 2010, you can create stunning charts, graphs, and data visualizations to communicate complex information effectively. One of the world’s leading Excel experts guides you through maximizing Excel 2010's visual features. Bill Jelen, known as "MrExcel," details when and how to utilize each chart type, demonstrating how to create impressive visuals while customizing them with themes, colors, and effects. Learn to craft charts that reveal trends, differences, and relationships, create stock analysis charts, and leverage Excel's flexible PivotCharts. You will also explore how to present data on maps using Microsoft MapPoint, utilize Sparklines and in-cell visualizations, and incorporate images and shapes with SmartArt. Additionally, discover how to export charts for external use and generate dynamic, customized charts automatically with Excel VBA. A dedicated chapter addresses evaluating the accuracy of charts created in Excel and recognizing misleading representations. This resource covers everything Excel users need for effective visual communication, from basic techniques to advanced methods like automatic chart generation with VBA, all part of the new MrExcel Library series, edited by Excel legend Bill Jelen.