{"id":2639,"date":"2014-10-03T14:42:25","date_gmt":"2014-10-03T18:42:25","guid":{"rendered":"http:\/\/aplusphysics.com\/wordpress\/regents\/?p=2639"},"modified":"2014-10-03T14:42:25","modified_gmt":"2014-10-03T18:42:25","slug":"creating-graphs-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/aplusphysics.com\/wordpress\/regents\/math\/creating-graphs-in-microsoft-excel\/","title":{"rendered":"Creating Graphs in Microsoft Excel"},"content":{"rendered":"
\n
\n

Basic tutorial for creating scatterplots in MS Excel<\/p>\n<\/p><\/div>\n<\/p><\/div>\n

<\/p>\n

\n
\n
\n

Open Microsoft Excel and choose Blank workbook.<\/h4>\n<\/p><\/div>\n
<\/div>\n
\n

Place your data into a table.<\/h4>\n
\n

Place your x-data in the left-hand column, and your y-data in the right-hand column.  Add column labels with units, but do NOT put units beside your numerical values.<\/p>\n<\/div>\n

\n
\n\t\t\t\t\t\t\t\t\"\"<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
<\/div>\n
\n

Highlight the data you want to graph, choose the Insert tab at the top of the screen, then choose the scatterplot symbol from the Charts section.<\/h4>\n
\n
\n\t\t\t\t\t\t\t\t\"\"<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
<\/div>\n
\n

Choose the upper-left version of the scatter plot and you should see your chart appear.<\/h4>\n
\n
\n\t\t\t\t\t\t\t\t\"\"<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
<\/div>\n
\n

Choose Quick Layout and select a chart format to add your axis labels.  <\/h4>\n
\n

The upper-left option is usually a good bet.<\/p>\n<\/div>\n

\n
\n\t\t\t\t\t\t\t\t\"\"<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
<\/div>\n
\n

Right click on one of your data points and choose "Add Trendline" to have Excel attempt to fit your data.<\/h4>\n
\n
\n\t\t\t\t\t\t\t\t\"\"<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
<\/div>\n
\n

Choose the type of fit you want from the Trendline Options menu.<\/h4>\n
\n

Typically you will want a linear fit, but Excel can attempt other fits.<\/p>\n

Pay special attention to the three options at the bottom of the screen.  If you are certain that 0,0 is a data point for your graph, you can force Excel to include that in its model by selecting "Set Intercept" and making sure it is zero.  To add the equation of the line to your chart (helpful in determining the slope and y-intercept), choose "Display Equation on chart."  Finally, if you want to know how well Excel was able to fit your data, you can show the R-squared value on your chart by choosing the final option.  R-squared values close to 1 indicate very good fits.  R-squared values close to 0 indicate extremely poor fits.<\/p>\n<\/div>\n

\n
\n\t\t\t\t\t\t\t\t\"\"<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
<\/div>\n
\n

Printing your graph: Select your graph, choose File –> Print, and select our printer (#3033).<\/h4>\n<\/p><\/div>\n
<\/div>\n<\/p><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Basic tutorial for creating scatterplots in MS Excel<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[266],"tags":[],"class_list":["post-2639","post","type-post","status-publish","format-standard","hentry","category-math"],"yoast_head":"\nCreating Graphs in Microsoft Excel - Regents Physics<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/aplusphysics.com\/wordpress\/regents\/math\/creating-graphs-in-microsoft-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating Graphs in Microsoft Excel - Regents Physics\" \/>\n<meta property=\"og:description\" content=\"Basic tutorial for creating scatterplots in MS Excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/aplusphysics.com\/wordpress\/regents\/math\/creating-graphs-in-microsoft-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Regents Physics\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/aplusphysics\" \/>\n<meta property=\"article:published_time\" content=\"2014-10-03T18:42:25+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/aplusphysics.com\/wordpress\/regents\/wp-content\/uploads\/2014\/10\/place-your-data-into-a-table.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@aplusphysics\" \/>\n<meta name=\"twitter:site\" content=\"@aplusphysics\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/math\\\/creating-graphs-in-microsoft-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/math\\\/creating-graphs-in-microsoft-excel\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/#\\\/schema\\\/person\\\/c2ac2abe916d9f213b6cb0d57c685d46\"},\"headline\":\"Creating Graphs in Microsoft Excel\",\"datePublished\":\"2014-10-03T18:42:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/math\\\/creating-graphs-in-microsoft-excel\\\/\"},\"wordCount\":301,\"publisher\":{\"@id\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/math\\\/creating-graphs-in-microsoft-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/wp-content\\\/uploads\\\/2014\\\/10\\\/place-your-data-into-a-table.png\",\"articleSection\":[\"Math\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/math\\\/creating-graphs-in-microsoft-excel\\\/\",\"url\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/math\\\/creating-graphs-in-microsoft-excel\\\/\",\"name\":\"Creating Graphs in Microsoft Excel - Regents Physics\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/math\\\/creating-graphs-in-microsoft-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/math\\\/creating-graphs-in-microsoft-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/wp-content\\\/uploads\\\/2014\\\/10\\\/place-your-data-into-a-table.png\",\"datePublished\":\"2014-10-03T18:42:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/math\\\/creating-graphs-in-microsoft-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/math\\\/creating-graphs-in-microsoft-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/math\\\/creating-graphs-in-microsoft-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/wp-content\\\/uploads\\\/2014\\\/10\\\/place-your-data-into-a-table.png\",\"contentUrl\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/wp-content\\\/uploads\\\/2014\\\/10\\\/place-your-data-into-a-table.png\",\"width\":200,\"height\":315},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/math\\\/creating-graphs-in-microsoft-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating Graphs in Microsoft Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/#website\",\"url\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/\",\"name\":\"Regents Physics\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/#organization\",\"name\":\"APlusPhysics\",\"url\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/wp-content\\\/uploads\\\/2015\\\/06\\\/APlusPhysics_Logo_HDef.png\",\"contentUrl\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/wp-content\\\/uploads\\\/2015\\\/06\\\/APlusPhysics_Logo_HDef.png\",\"width\":1500,\"height\":1069,\"caption\":\"APlusPhysics\"},\"image\":{\"@id\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/aplusphysics\",\"https:\\\/\\\/x.com\\\/aplusphysics\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/aplusphysics\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/fizziksguy\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/#\\\/schema\\\/person\\\/c2ac2abe916d9f213b6cb0d57c685d46\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/242edd616e1085518670004a090bc15c23eebb49a6b9191f1e1b23ea6d8567db?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/242edd616e1085518670004a090bc15c23eebb49a6b9191f1e1b23ea6d8567db?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/242edd616e1085518670004a090bc15c23eebb49a6b9191f1e1b23ea6d8567db?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\\\/\\\/aplusphysics.com\\\/wordpress\\\/regents\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating Graphs in Microsoft Excel - Regents Physics","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/aplusphysics.com\/wordpress\/regents\/math\/creating-graphs-in-microsoft-excel\/","og_locale":"en_US","og_type":"article","og_title":"Creating Graphs in Microsoft Excel - Regents Physics","og_description":"Basic tutorial for creating scatterplots in MS Excel","og_url":"https:\/\/aplusphysics.com\/wordpress\/regents\/math\/creating-graphs-in-microsoft-excel\/","og_site_name":"Regents Physics","article_publisher":"https:\/\/www.facebook.com\/aplusphysics","article_published_time":"2014-10-03T18:42:25+00:00","og_image":[{"url":"http:\/\/aplusphysics.com\/wordpress\/regents\/wp-content\/uploads\/2014\/10\/place-your-data-into-a-table.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_creator":"@aplusphysics","twitter_site":"@aplusphysics","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/aplusphysics.com\/wordpress\/regents\/math\/creating-graphs-in-microsoft-excel\/#article","isPartOf":{"@id":"https:\/\/aplusphysics.com\/wordpress\/regents\/math\/creating-graphs-in-microsoft-excel\/"},"author":{"name":"admin","@id":"https:\/\/aplusphysics.com\/wordpress\/regents\/#\/schema\/person\/c2ac2abe916d9f213b6cb0d57c685d46"},"headline":"Creating Graphs in Microsoft Excel","datePublished":"2014-10-03T18:42:25+00:00","mainEntityOfPage":{"@id":"https:\/\/aplusphysics.com\/wordpress\/regents\/math\/creating-graphs-in-microsoft-excel\/"},"wordCount":301,"publisher":{"@id":"https:\/\/aplusphysics.com\/wordpress\/regents\/#organization"},"image":{"@id":"https:\/\/aplusphysics.com\/wordpress\/regents\/math\/creating-graphs-in-microsoft-excel\/#primaryimage"},"thumbnailUrl":"http:\/\/aplusphysics.com\/wordpress\/regents\/wp-content\/uploads\/2014\/10\/place-your-data-into-a-table.png","articleSection":["Math"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/aplusphysics.com\/wordpress\/regents\/math\/creating-graphs-in-microsoft-excel\/","url":"https:\/\/aplusphysics.com\/wordpress\/regents\/math\/creating-graphs-in-microsoft-excel\/","name":"Creating Graphs in Microsoft Excel - Regents Physics","isPartOf":{"@id":"https:\/\/aplusphysics.com\/wordpress\/regents\/#website"},"primaryImageOfPage":{"@id":"https:\/\/aplusphysics.com\/wordpress\/regents\/math\/creating-graphs-in-microsoft-excel\/#primaryimage"},"image":{"@id":"https:\/\/aplusphysics.com\/wordpress\/regents\/math\/creating-graphs-in-microsoft-excel\/#primaryimage"},"thumbnailUrl":"http:\/\/aplusphysics.com\/wordpress\/regents\/wp-content\/uploads\/2014\/10\/place-your-data-into-a-table.png","datePublished":"2014-10-03T18:42:25+00:00","breadcrumb":{"@id":"https:\/\/aplusphysics.com\/wordpress\/regents\/math\/creating-graphs-in-microsoft-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/aplusphysics.com\/wordpress\/regents\/math\/creating-graphs-in-microsoft-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/aplusphysics.com\/wordpress\/regents\/math\/creating-graphs-in-microsoft-excel\/#primaryimage","url":"https:\/\/aplusphysics.com\/wordpress\/regents\/wp-content\/uploads\/2014\/10\/place-your-data-into-a-table.png","contentUrl":"https:\/\/aplusphysics.com\/wordpress\/regents\/wp-content\/uploads\/2014\/10\/place-your-data-into-a-table.png","width":200,"height":315},{"@type":"BreadcrumbList","@id":"https:\/\/aplusphysics.com\/wordpress\/regents\/math\/creating-graphs-in-microsoft-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/aplusphysics.com\/wordpress\/regents\/"},{"@type":"ListItem","position":2,"name":"Creating Graphs in Microsoft Excel"}]},{"@type":"WebSite","@id":"https:\/\/aplusphysics.com\/wordpress\/regents\/#website","url":"https:\/\/aplusphysics.com\/wordpress\/regents\/","name":"Regents Physics","description":"","publisher":{"@id":"https:\/\/aplusphysics.com\/wordpress\/regents\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/aplusphysics.com\/wordpress\/regents\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/aplusphysics.com\/wordpress\/regents\/#organization","name":"APlusPhysics","url":"https:\/\/aplusphysics.com\/wordpress\/regents\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/aplusphysics.com\/wordpress\/regents\/#\/schema\/logo\/image\/","url":"https:\/\/aplusphysics.com\/wordpress\/regents\/wp-content\/uploads\/2015\/06\/APlusPhysics_Logo_HDef.png","contentUrl":"https:\/\/aplusphysics.com\/wordpress\/regents\/wp-content\/uploads\/2015\/06\/APlusPhysics_Logo_HDef.png","width":1500,"height":1069,"caption":"APlusPhysics"},"image":{"@id":"https:\/\/aplusphysics.com\/wordpress\/regents\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/aplusphysics","https:\/\/x.com\/aplusphysics","https:\/\/www.linkedin.com\/in\/aplusphysics\/","https:\/\/www.youtube.com\/user\/fizziksguy"]},{"@type":"Person","@id":"https:\/\/aplusphysics.com\/wordpress\/regents\/#\/schema\/person\/c2ac2abe916d9f213b6cb0d57c685d46","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/242edd616e1085518670004a090bc15c23eebb49a6b9191f1e1b23ea6d8567db?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/242edd616e1085518670004a090bc15c23eebb49a6b9191f1e1b23ea6d8567db?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/242edd616e1085518670004a090bc15c23eebb49a6b9191f1e1b23ea6d8567db?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/aplusphysics.com\/wordpress\/regents\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/aplusphysics.com\/wordpress\/regents\/wp-json\/wp\/v2\/posts\/2639","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aplusphysics.com\/wordpress\/regents\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aplusphysics.com\/wordpress\/regents\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aplusphysics.com\/wordpress\/regents\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aplusphysics.com\/wordpress\/regents\/wp-json\/wp\/v2\/comments?post=2639"}],"version-history":[{"count":1,"href":"https:\/\/aplusphysics.com\/wordpress\/regents\/wp-json\/wp\/v2\/posts\/2639\/revisions"}],"predecessor-version":[{"id":2640,"href":"https:\/\/aplusphysics.com\/wordpress\/regents\/wp-json\/wp\/v2\/posts\/2639\/revisions\/2640"}],"wp:attachment":[{"href":"https:\/\/aplusphysics.com\/wordpress\/regents\/wp-json\/wp\/v2\/media?parent=2639"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplusphysics.com\/wordpress\/regents\/wp-json\/wp\/v2\/categories?post=2639"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplusphysics.com\/wordpress\/regents\/wp-json\/wp\/v2\/tags?post=2639"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}