Transcript
![Page 1: Excel Spread Sheet- plug in dates along top row skipping column A](https://reader036.vdocuments.us/reader036/viewer/2022062404/55156cd655034674578b4e5b/html5/thumbnails/1.jpg)
Excel Spread Sheet- plug in dates along top row skipping column A
![Page 2: Excel Spread Sheet- plug in dates along top row skipping column A](https://reader036.vdocuments.us/reader036/viewer/2022062404/55156cd655034674578b4e5b/html5/thumbnails/2.jpg)
Write one goal per "sheet" skip line #1
![Page 3: Excel Spread Sheet- plug in dates along top row skipping column A](https://reader036.vdocuments.us/reader036/viewer/2022062404/55156cd655034674578b4e5b/html5/thumbnails/3.jpg)
Data Points align under dates
![Page 4: Excel Spread Sheet- plug in dates along top row skipping column A](https://reader036.vdocuments.us/reader036/viewer/2022062404/55156cd655034674578b4e5b/html5/thumbnails/4.jpg)
Hi-light with Mouse Row 1 and 2 with all dates/data points
![Page 5: Excel Spread Sheet- plug in dates along top row skipping column A](https://reader036.vdocuments.us/reader036/viewer/2022062404/55156cd655034674578b4e5b/html5/thumbnails/5.jpg)
After hi-lighting click graph symbol button and box on right will appear
![Page 6: Excel Spread Sheet- plug in dates along top row skipping column A](https://reader036.vdocuments.us/reader036/viewer/2022062404/55156cd655034674578b4e5b/html5/thumbnails/6.jpg)
Change to line
![Page 7: Excel Spread Sheet- plug in dates along top row skipping column A](https://reader036.vdocuments.us/reader036/viewer/2022062404/55156cd655034674578b4e5b/html5/thumbnails/7.jpg)
After change to lineselect next- boxat right will appear
![Page 8: Excel Spread Sheet- plug in dates along top row skipping column A](https://reader036.vdocuments.us/reader036/viewer/2022062404/55156cd655034674578b4e5b/html5/thumbnails/8.jpg)
Check chart title
![Page 9: Excel Spread Sheet- plug in dates along top row skipping column A](https://reader036.vdocuments.us/reader036/viewer/2022062404/55156cd655034674578b4e5b/html5/thumbnails/9.jpg)
Enter labels for sides
![Page 10: Excel Spread Sheet- plug in dates along top row skipping column A](https://reader036.vdocuments.us/reader036/viewer/2022062404/55156cd655034674578b4e5b/html5/thumbnails/10.jpg)
After labelsselect next
![Page 11: Excel Spread Sheet- plug in dates along top row skipping column A](https://reader036.vdocuments.us/reader036/viewer/2022062404/55156cd655034674578b4e5b/html5/thumbnails/11.jpg)
Change to new sheet
![Page 12: Excel Spread Sheet- plug in dates along top row skipping column A](https://reader036.vdocuments.us/reader036/viewer/2022062404/55156cd655034674578b4e5b/html5/thumbnails/12.jpg)
Graph will appear- may remove legend on right-
![Page 13: Excel Spread Sheet- plug in dates along top row skipping column A](https://reader036.vdocuments.us/reader036/viewer/2022062404/55156cd655034674578b4e5b/html5/thumbnails/13.jpg)
Can insert line for intervention
![Page 14: Excel Spread Sheet- plug in dates along top row skipping column A](https://reader036.vdocuments.us/reader036/viewer/2022062404/55156cd655034674578b4e5b/html5/thumbnails/14.jpg)
Can create label for intervention line- with text box insert
![Page 15: Excel Spread Sheet- plug in dates along top row skipping column A](https://reader036.vdocuments.us/reader036/viewer/2022062404/55156cd655034674578b4e5b/html5/thumbnails/15.jpg)
Can change direction by right clickon mouse and choose format text box