欢迎来到天天文库
浏览记录
ID:48039003
大小:2.20 MB
页数:312页
时间:2020-01-14
《咨询公司PPT模板.ppt》由会员上传分享,免费在线阅读,更多相关内容在行业资料-天天文库。
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
此文档下载收益归作者所有