1 / 14

Creating a Scatter Plot in Excel on Mac: Step-by-Step Guide

Learn how to create a scatter plot using Excel on your Mac. This step-by-step guide covers inserting your variables for the x-axis and y-axis, highlighting data points, and creating the scatter chart. You'll also find instructions on adding axis titles, adjusting gridlines, changing colors, and deleting the legend. Additionally, discover how to enhance your chart with a trendline, display the equation of the line, and show the R-squared value for better data analysis.

peony
Télécharger la présentation

Creating a Scatter Plot in Excel on Mac: Step-by-Step Guide

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. Creating a Scatter Plot On a Mac

  2. Data in Excel Spreadsheet • Insert the variable you want on the x-axis in the left column • Insert the variable you want on the y-axis in the right column

  3. Create the Chart • Highlight both variables, TV and GPA • Charts  Scatter  Marked Scatter

  4. Add Axis Titles • Chart Layout  Axis Title • Horizontal Axis  Below Axis  “TV (minutes)” • Vertical Axis  Rotated Title  “GPA”

  5. Delete Gridlines • Chart Layout  Gridlines  Horizontal Gridlines None

  6. Chart Title • Chart Layout  Chart Title  Above Chart

  7. Change Colors • Click on any point in the scatter plot • Format Fill  Choose color

  8. Legend • Chart Layout  Legend  No legend

  9. Scatter Plot

  10. Add a Trendline • Chart layout trendline linear trend

  11. Add the Equation of the Line • Chart Layout trendlinetrendline options • Click on options • Check display equation of the line

  12. Add r-squared value • Chart Layout trendlinetrendline options • Click on options • Check display r-squared value

  13. Line Color, Weight, etc. • Chart Layout TrendlineTrendline Options • Click on Line  change color • Click on weights  make thicker

  14. Scatter Plot

More Related