Graphs of simple and complex functions
To draw the graph of a function you first build a table of x values: write the starting value and a constant step, and AutoFill continues the rest. The formula for y is written once in the next row, and relative references copy it to all the x values. Select both rows, choose “Scatter” from the Charts group on the Insert tab and then the “Scatter with Smooth Lines” type: in this chart the x axis is a true numeric axis. An ordinary “Line” chart treats the x values as text labels and spaces them evenly, so if the steps are unequal the graph is distorted. The chart title and the axis titles are added through the chart elements. If you write the coefficients in separate cells and join them with absolute references, the graph is redrawn at once when you change them. In Excel SIN, COS and TAN expect the angle in radians, so convert degrees with RADIANS().
A school science club wants to see how the height of a thrown ball changes with time. They calculated a table of values with a formula and joined the points with a curve. The highest point of the curve showed when the ball was at its greatest height.
Engineers, weather specialists and economists draw graphs from tables of values to see how something changes.
On squared paper make a table for x = 0, 1, 2, 3, 4 with y equal to half of x, plot the points, join them and write down what shape the line has.
“Guess the graph”: the teacher shows only three points of y = x² – 4x + 3; pairs calculate the other points in their notebooks and then compare them with the graph drawn in Excel.