Today, the editor brings the “Production of Planar Quadrant Map in Excel”.
Welcome to visit!
萌说新语——EXCEL中平面四象限图制作01:39来自LearningYard学苑1. 输入自变量 1. Input arguments新建空白的工作表，先输入函数的自变量：在A列的A1格输入“X=”，表明这是自变量。Create a new blank worksheet and first input the function's arguments: enter "X=" in the A1 cell of column A to indicate that this is the argument.
2. Enter each value of the independent variable one by one in the A2, B2, and subsequent cells of columns A and B; Because I want to apply it to SWOT model analysis, I already have the data, as shown below:
3.绘制折线图 3. Draw a line chart点击工具栏上的“图表向导”按钮，选择“X，Y散点图”，然后在出现的“X，Y散点图”类型中选择“带直线的折线图”。此时可察看即将绘制的函数图像，发现并不是所要的函数曲线。Click on the "Chart Wizard" button on the toolbar, select "X, Y Scatter Chart", and then select "Line Chart with Line" from the "X, Y Scatter Chart" type that appears. At this point, you can observe the upcoming function image and find that it is not the desired function curve.4.更新散点图 4. Update Scatter Chart我们需要的是结构闭环的四象限图，所以小编在现在数据的基础上增加了一个闭环数据，如下图所示：What we need is a four quadrant diagram with a closed-loop structure, so the editor has added a closed-loop data on top of the current data, as shown in the following figure:5.优化格式 5. Optimize format我们可以看到数据的左右坐标轴并没有对称，所以点击横坐标轴将数据改成对称状态。更改之后如下所示：We can see that the left and right axes of the data are not symmetrical, so click on the horizontal axis to change the data to a symmetrical state. After the change, it is as follows:
