WPS table How to draw two times function curve

1, start the WPS table, set the value of ABC, that is, two times the function of three coefficients.

2, we know that A is not 0, so it is necessary to set the data validity, set to not allow 0.

3, the following to make the function expression, the square number we can select in the special symbol.

4, we need to use the formula code, give a different ABC value, the resulting curve is also different. so function expression: = "y=" &if (E3=1, "x ²",e3& "x ²") &if (f3<0,f3& "x", if (F3=0, "", if (F3=1, "+x", "+" &F3& " X ")) &if (G3<0,g3,if (G3=0," "," + "&g3)), we know that the formula for the symmetric axis of the two quadratic function is x=-b/2a, so we can enter the formula in the B3 cell: =round ($F $3/( -2* $E $) -13+row (), 0), padding, and then in C3 input = $E $3*b3^2+ $F $3*b3+ $G $.

5, data generation finished, select XY scatter chart, type selected as numerous points smooth line scatter plot.

6, the source data settings, switch to the Data Region tab, click the Data area after the options, give the data area.

7, the chart has basically generated finished, we slightly beautify, change the curve color, delete some unnecessary things.