資源描述:
《咨詢公司PPT模板.ppt》由會員上傳分享,免費在線閱讀,更多相關(guān)內(nèi)容在行業(yè)資料-天天文庫。
1、Subtitle?linemaximumChartunitsofmeasureActiontitle2linesmaximumRoadmapDeviationbarchartHints:1Insertrowsasrequired(eachwilladoptadifferentcolor)2Double-clickonabartochangethecolor3Dragdatavaluesoutsidetherowsmanually4AddlabelsmanuallyRangebarchartHints:1Enterthenu
2、mberforthespacebetweenthey-axisandthebarinthe“Space“row2Enterthewidthofthebarinthe“Group2“rowSlidingbarchartHints:1Insertrowsasrequired(eachwilladoptadifferentcolor)2Double-clickonabartochangethecolor3Dragdatavaluesoutsidethecolumnsmanually4Addlabelsmanually5Tocha
3、ngethewidthoftherowsselectChartOptionsandturnonthex-axis,thenuseFormatAxis/Scaletosetthelengthofthex-axis.Oncethescaleisset,useChartOptionsagaintoremovethex-axisPairedbarchartHints:1Thischartismadeoftwographs.Startwiththeleftone,itcontainstheaxistitles2Tochangethe
4、widthoftherowsselectChartOptionsandturnonthex-axis,thenuseFormatAxis/Scaletosetthelengthofthex-axis.Oncethescaleisset,useChartOptionsagaintoremovethex-axisSub-dividedbarchartHints:1Calculatethetotalandenteritinthe"Sum"row(whichisinatransparentbar)2Leftalignthetota
5、lvalue(whichisinatransparentbar)3Addthelegendnamesmanually4TochangethewidthoftherowsselectChartOptionsandturnonthex-axis,thenuseFormatAxis/Scaletosetthelengthofthex-axis.Oncethescaleisset,useChartOptionsagaintoremovethex-axisSub-divided100%barchartHints:1SelectFor
6、matSeriesLinestoadd/removetrendlines2AddlegendnamesmanuallyGroupedbarchartHints:1Selectadataseriesbyclickingwiththerightmousebuttononthebar2Chooseanoverlapintheoptionsmenu3AddgroupnamesmanuallyWaterfallchart1Hints:1Calculateandenterthevaluecorrespondingtotheareabe
7、lowthecolumnintherowmarked"Space"2Entertheheightofthecolumnintherowmarked"Column"row3Add/removecolumnsandrowsasrequired4Addserieslinesbetweenthecolumnsmanually,ifrequired5TochangetheheightofthecolumnsselectChartOptionsandturnonthey-axis,thenuseFormatAxis/Scaletose
8、tthelengthofthey-axis(checkthe“Automatic”button).Oncethescaleisset,useChartOptionsagaintoremovethey-axisWaterfallchart2Hints:1Calculateandenterthevaluec