How to automatically generate sensitivity analysis charts using excel

Method: 1. Select the data table and click "Insert" - "Line Chart" - "Two-dimensional Line Chart" - "Line Chart"; 2. Right-click the drawing area and click "Select Data"; 3 , click "Switch Rows/Columns"; 4. Right-click the abscissa axis in the generated graph and set the axis format; 5. Click "Axis Options" - "Axis Crossing" and change the value to 2.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Sensitivity analysis is often needed in project financial analysis, which is to express the impact of a certain variable on the final result when it changes by a certain proportion. It will be clearer and easier to understand if sensitivity analysis is expressed in the form of a diagram. Let me introduce to you how to automatically generate sensitivity analysis charts using Excel.

Method/steps:

Select the data table and click Insert → Line Chart → Two-dimensional Line Chart → Line Chart

The following graph appears

Right-click in the drawing area→Select data

Click in the pop-up dialog box "Switch rows/columns"

Right-click on the abscissa axis in the generated graph, and left-click to set the axis format

In the pop-up dialog box, change 1 to 2 in the "Coordinate Axis Options" → "Coordinate Axis Crossing" option (indicating the second coordinate point of each coordinate axis)

You can generate a sensitivity analysis chart, and then set the color, line type, line width, etc. of each polyline to make a sensitivity analysis chart that suits you

Related learning recommendations: excel tutorial

The above is the detailed content of How to automatically generate sensitivity analysis charts using excel. For more information, please follow other related articles on the PHP Chinese website!