GRAPH

Back to HOME =HOW TO DRAW A GRAPH IN EXCEL= The best option is a scatter graph which shows points and allows a trendline. media type="custom" key="25334892"

In Sheets, a scatter graph has no error bars nor trendline (March 2014). We use a line graph with an **invisible line** and we add the trendline manually. On the sheet, choose **Chart.** Select the two **data ranges** (Independent variable and Dependent variable). Check **'Use column A as labels**' or whichever column is the IV.
 * HOW TO DRAW A GRAPH IN GOOGLE SHEETS **
 * START TAB**

Line
 * CHARTS TAB**

Adjust max and min quantities if needed: eg Min quantity may be zero if you want to see the origin.
 * CUSTOMISE TAB**
 * Title**: IV against DV for [situation] eg Distance against time for a speeding bullet
 * Legend**: None
 * Axis titles**: Quantity and units
 * Gridlines**: add 9 minor gridlines per major (which creates 10 squares).
 * Line thickness**: 0px - makes it invisible
 * Point size**: 2px - makes it small

Any other customisations which would make your graph communicate to the reader.

Save the graph as an image and print out on A3. Manually add the trendline (either straight or curved, depending on the data). For IB practicals, if the graph is straight, you are required to add max and min gradients from the first to the last point.
 * TO ADD A TRENDLINE**

Old school: draw a large right angled triangle and work out rise/run (get the units right). Repeat for max and min lines. Finally, calculate **gradient ± ½(max - min)** eg 9.82 ms -2 ± 0.02 ms -2
 * CALCULATE THE GRADIENTS**