Title: Excel Charts Using Formulas \{put this title on your report, points off if you do not\} 1. Open EXCEL to a new worksheet. 2. Enter the following data 3. In column B \{starting with the cell that aligns with the value in column A} put in the formula that converts Celsius to Fahrenheit given below. 4. Fill in column B with the corresponding Fahrenheit values. 5. Make a chart \{Fahrenheit vs. Celsius\} as follows; 6. Highlight the values in the A and B columns using the mouse. 7. Click on the "insert"tab. It is on the standard (top) toolbar. 8. In the Chart section of the tool bar, click on "Scatter". 9. A graph will appear with the Celsius values on the horizontal axis 10. Annotate the graph as follows; 11. Click on the next tab on the toolbar "Layout" 12. Above the ' labels' section, click on "Axis Titles", then "Primary Horizontal Axis title" 13. Select "Title Below Axis" and in the box type in "Celsius" 14. Go back to "Axis Titles"and then click on "Primary Vertical Axis Title". 15. Select "Rotated Title" and type in "Fahrenheit". 16. Go back to the tool bar and click on "Chart Title". 17. Type in "Fahrenheit vs. Celsius" 18. Did you get what you expected? 19. Repeat the above \{starting at 5 above\} for a graph of "Celsius vs. Fahrenheit". Temperature Conversion Relations DegF=(9/5)degC+32 Or use following DegF=(degC+40)(9/5)40