资源描述
Tornadodiagram,项目风险管理风险管理规划风险识别风险定性分析风险定量分析,定量风险分析和建模技术,敏感性分析(龙卷风图)预期货币价值分析(决策树分析),A公司除尘工程项目风险管理研究,TornadodiagraminExcel,Selectthedata,excludingtheDeltacolumnOntheInsertribbon,chooseBar.PickClusteredBar(firstoneinthe2-Dsection)Right-clickonthehorizontalaxis,chooseFormatAxis.OnthebottomoftheAxisOptionspanelookforVerticalAxiscrosses:,choosetheAxisvalueradiobutton,andtypeyourbasecasevalue(7intheexample)Withoutclosingthewindow,choosetheverticalaxisofthechart.AgainonAxisOptions,checktheboxCategoriesinreverseorder,andsettheAxisLabelsmenutoLowWithoutclosingthewindow,clickonanyofthebars,whichshouldbringtheSeriesOptionspane.MovethesliderSeriesOverlapcompletelytotheright(Overlapped).,
展开阅读全文