Charts and Graphs: Microsoft Excel 2010

UsingExcel2010,it'spossibletocreatebreathtakingcharts,graphs,andotherdatavisualizations-andcommunicateeventhemostcomplexdatamoreeffectivelythaneverbefore.InChartsandGraphs,oneoftheworld'sleadingExcelexpertsshowexactlyhowtomakethemostofExcel2010'sunprecedentedvisualfeatures.BillJelen("MrExcel")explainsexactlywhenandhowtouseeachtypeofExcelchart,thenwalksthroughcreatingsuperbvisualsandcustomizingthemwiththemes,colors,andeffects.Jelenshowshowtocraftchartsthatilluminatetrends,differences,andrelationships;howtocreatestockanalysischarts;howtouseExcel'sflexiblePivotCharts;andevenhowtopresentdataonmapswithMicrosoftMapPoint.YouwilldiscoverhowtomakethemostofExcel2010'snewSparklinesandotherin-cellvisualizations;howtoincorporateadditionalimagesandshapeswithSmartArt;howtoexportchartsforuseoutsideofExcel;andhowtogeneratedynamic,customizedchartsautomaticallywithExcelVBA.There'sevenafullchapteronassessingthetruthofchartscreatedinExcel-andrecognizingwhensomeone'stryingtolietoyou!ThisbookispartofthenewMrExcelLibraryseries.