Using Excel to Make a Graph 1) Open Excel and create a new workbook. Type "Temperature" in cell A1 and "Time" in cell B1. 2) Type in average temperatures for cold, room temp., and hot water collected from class data. 3) Select the cells with text (A1-B4) and create a column chart under "Charts".