View as Microsoft Word* | View as PDF
Instructions for Creating a Graph
- Highlight the cells that contain the data you want to show in a chart or graph (most likely this will be the sunrise and sunset cells for one garden location).
- Choose Chart from the Insert menu.
- Click the Line graph chart type, then click the Next button.
- On the Data Range tab, be sure Columns is selected next to Series In, and then click Next.
- In step 3 of the Chart Wizard, add titles for the chart and its axes on the Titles tab, and click Next.
- Place the chart as an object on the original worksheet so that you can see the worksheet entries as you examine the chart or place it on a separate sheet, and then click Finish.
- Review the sample below:

< Return to Wave of Spring