Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Can anyone advise the steps involved to produce a sensitivity analysis graph
in Excel 2007. The produced graph has lines that disect each other. I have produced the sensitivity tables but need the graph to complete the exercise. Help! |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
WebberD -
One kind of "sensitivity analysis graph" is the spider chart. For an example, see the "SensIt Spider 2" worksheet in the sens131e.xls workbook, available from the Download page at http://www.treeplan.com. If your "sensitivity tables" are arranged similarly, you can select objects of that spider chart to see how it was constructed. If you want a different kind of chart, please provide more details. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "WebberD" wrote in message ... Can anyone advise the steps involved to produce a sensitivity analysis graph in Excel 2007. The produced graph has lines that disect each other. I have produced the sensitivity tables but need the graph to complete the exercise. Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I do sensitivity analysis in excel 2007? | Excel Worksheet Functions | |||
Excel Sensitivity (What If) analysis | Charts and Charting in Excel | |||
Sensitivity analysis | Excel Worksheet Functions |