1. Excel Charts and Graphs Instructor Heidi Lyons

2. Going from SAS into Excel • First, make sure you have the HTML output turned on • Tools • Options • Preferences • Results • Create HTML

4. Using the Chart Wizard

5. Using Chart Wizard • Select the cells that contain the numbers wanted in the chart • Click on the Wizard tool • Choose a type of chart • Data ranges • Added Detail • As object in or As new sheet

6. Using the Chart Wizard

7. Using the Chart Wizard

8. Using the Chart Wizard

9. Using the Chart Wizard

10. Using the Chart Wizard

11. Using the Chart Wizard

12. More than one Data Series • Example

16. Other Types of Charts • There are 14 different types of Charts • Column • Bar • Line • Pie • Scatter • Surface • Cylinder, Cone, and Pyramid

17. Bar

18. Line

19. Pie

20. Pie • Example

21. Scatter • Residuals • X-Y graphs

22. Running Regression in Excel • Very limited • Tool • Add-Ins….

23. Running Regression in Excel • Tools • Data Analysis

24. Running Regression in Excel • Y-range put in your dependent variables values • Must be a column • Same with X-range • Ask for output in new workbook • Ask for residuals

27. Scatter

28. Cylinder, Cone, and Pyramid

29. Combination

30. Combination

31. Population Pyramid

36. How to Fix it • Double click on the vertical axis • Pick Format Axis. • Click Patterns tabs→ Major tick=None →Minor tick=None →Tick mark labels= Low • Ok

37. How to Fix it • Double click on the horizontal axis • Pick Format Axis. • Click Number tabs→ Category = Custom →Type = 0 • Ok

38. How to Fix it • Click on the Bars • Go to Options • Overlap=100 • Type=0 • OK

40. Getting the Cart into Word • Right Click • Copy • Edit • Paste Special

41. Paste Special

42. Getting your Chart into Power Point

43. Other CFDR Help • Come on down • CFDR: Bowling Green State University