1 / 43

Excel Charts and Graphs

Excel Charts and Graphs. Instructor Heidi Lyons. Going from SAS into Excel. First, make sure you have the HTML output turned on Tools Options Preferences Results Create HTML. Using the Chart Wizard. Using Chart Wizard. Select the cells that contain the numbers wanted in the chart

jase
Download Presentation

Excel Charts and Graphs

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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

  3. Using the Chart Wizard

  4. 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

  5. Using the Chart Wizard

  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. More than one Data Series • Example

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

  13. Bar

  14. Line

  15. Pie

  16. Pie • Example

  17. Scatter • Residuals • X-Y graphs

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

  19. Running Regression in Excel • Tools • Data Analysis

  20. 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

  21. Scatter

  22. Cylinder, Cone, and Pyramid

  23. Combination

  24. Combination

  25. Population Pyramid

  26. 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

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

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

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

  30. Paste Special

  31. Getting your Chart into Power Point

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

More Related