We will assume that the functions whose graphs we need to build are always located in columns. Moreover, in column a, let there be the values of the variable x, and in columns B, C … the values of the functions f1.f2,… respectively.
Excel has a special chart type called “graph”.
With it, you can plot the dependence of data in a column (for example, In) on the line number. Regardless of which category axis labels we set. (Even if the values from column A are signed on the X-axis, the graph will not express the dependence f1(x) in the general case). It is built like a very ordinary diagram. You can plot multiple function graphs on a single diagram. If column A contains an arithmetic progression, then we can assume that the graph of the constructed function expresses the dependence f1(x). This method of plotting a function is convenient if the function is given a tabulated function. In step 2, you need to specify the corresponding cells of column B as a range, and on the “Row” tab, in the “X-axis Signatures” line, specify the corresponding cells of column A.
The second method of constructing a dependency graph “is more universal. It is necessary to build a diagram of the “Dot” type. (If you choose the third type, it will be completely similar to the graph). In the second step, we specify column B as the range. And on the row tab, we specify column A as the “X Value”. If we want to build several graphs (for example, graphs of functions f1 and f2) on one diagram, we need to click the “Add” button, and for the added series, specify column C in the column “Y Values”, column A in the column “X Values”. Similarly, using a “Dot” type diagram, you can draw a graph of some non-trivial dependence. For example, f1(f2).