{"id":168564,"date":"2021-05-28T09:45:59","date_gmt":"2021-05-28T07:45:59","guid":{"rendered":"http:\/\/sftarticles.wpenginepowered.com\/en\/?p=168564"},"modified":"2025-07-01T21:05:28","modified_gmt":"2025-07-02T04:05:28","slug":"how-to-make-a-graph-on-excel-in-4-steps","status":"publish","type":"post","link":"https:\/\/cms-articles.softonic.io\/en\/how-to-make-a-graph-on-excel-in-4-steps\/","title":{"rendered":"How to Make a Graph on Microsoft Excel in 4 Steps"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Using Microsoft Excel on <a href=\"https:\/\/microsoft-excel.en.softonic.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">Windows <\/a>and <a href=\"https:\/\/microsoft-excel-2011.en.softonic.com\/mac\" target=\"_blank\" rel=\"noreferrer noopener\">Mac<\/a> is becoming one of the best ways to store, manipulate and analyze data. With many different features specifically for data analysis, it is easy to understand why the program is so popular. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">One of the ways you can present your data is through the use of graphs and pie charts. This may sound complicated to do within a computer program, but fear not, Excel has made it a simple process.<\/p>\n\n\n<div class=\"howto_container schema-howto-acf-block\"><ol><li><div class=\"howto_item\"><h2>Enter Data Into the Spreadsheet<\/h2><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/articles-img.sftcdn.net\/auto-mapping-folder\/sites\/3\/2021\/05\/How-to-Make-a-Graph-on-Microsoft-Excel-step-1.jpg\" alt=\"How to Make a Graph on Microsoft Excel\" width=\"427\" height=\"156\"><p><span style=\"font-weight: 400;\">Before you can start to make a <\/span><span style=\"font-weight: 400;\">graph<\/span><span style=\"font-weight: 400;\">, you first need to have <\/span><span style=\"font-weight: 400;\">data<\/span><span style=\"font-weight: 400;\"> available. In your <\/span><span style=\"font-weight: 400;\">Excel<\/span><span style=\"font-weight: 400;\"> spreadsheet add the <\/span><span style=\"font-weight: 400;\">data<\/span><span style=\"font-weight: 400;\"> that you want to create the <\/span><span style=\"font-weight: 400;\">graph<\/span><span style=\"font-weight: 400;\"> for. Also, make sure to add clear headings to your columns and rows as this will be included in your graph\u2019s <\/span><span style=\"font-weight: 400;\">axis<\/span><span style=\"font-weight: 400;\"> and is needed to clearly understand what you are looking at.<\/span><\/p>\n<\/div><\/li><li><div class=\"howto_item\"><h2>Select the Range of Data to Be Used in the Graph<\/h2><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/articles-img.sftcdn.net\/auto-mapping-folder\/sites\/3\/2021\/05\/How-to-Make-a-Graph-on-Microsoft-Excel-step-2.jpg\" alt=\"How to Make a Graph on Microsoft Excel\" width=\"512\" height=\"245\"><p><span style=\"font-weight: 400;\">Next, you need to highlight the <\/span><span style=\"font-weight: 400;\">data<\/span><span style=\"font-weight: 400;\"> that you want to use in your <\/span><span style=\"font-weight: 400;\">graph<\/span><span style=\"font-weight: 400;\">. You can do this by clicking and dragging the mouse across the cells you want to use. Remember to include the headings.<\/span><\/p>\n<\/div><\/li><li><div class=\"howto_item\"><h2>Choose Chart Type<\/h2><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/articles-img.sftcdn.net\/auto-mapping-folder\/sites\/3\/2021\/05\/How-to-Make-a-Graph-on-Microsoft-Excel-step-3.jpg\" alt=\"How to Make a Graph on Microsoft Excel\" width=\"512\" height=\"70\"><p><span style=\"font-weight: 400;\">With the data selected <\/span><span style=\"font-weight: 400;\">click<\/span><span style=\"font-weight: 400;\"> on \u2018Insert\u2019 in the top ribbon, now navigate to the dropdown list of all the \u2018Recommended Charts\u2019 and choose the <\/span><span style=\"font-weight: 400;\">graph<\/span><span style=\"font-weight: 400;\"> that will best represent your <\/span><span style=\"font-weight: 400;\">data<\/span><span style=\"font-weight: 400;\"> from the various options. Once you\u2019ve clicked on the chart type, the program will automatically generate your <\/span><span style=\"font-weight: 400;\">graph<\/span><span style=\"font-weight: 400;\"> from the <\/span><span style=\"font-weight: 400;\">data<\/span><span style=\"font-weight: 400;\"> you selected.<\/span><\/p>\n<\/div><\/li><li><div class=\"howto_item\"><h2>Check and Improve Your Graph<\/h2><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/articles-img.sftcdn.net\/auto-mapping-folder\/sites\/3\/2021\/05\/How-to-Make-a-Graph-on-Microsoft-Excel-step-4.jpg\" alt=\"How to Make a Graph on Microsoft Excel\" width=\"394\" height=\"246\"><p><span style=\"font-weight: 400;\">Now that the <\/span><span style=\"font-weight: 400;\">graph<\/span><span style=\"font-weight: 400;\"> has been generated you can check that the elements appear correct, and make adjustments such as the size of the graph, title of the <\/span><span style=\"font-weight: 400;\">graph<\/span><span style=\"font-weight: 400;\"> and <\/span><span style=\"font-weight: 400;\">axis<\/span><span style=\"font-weight: 400;\">, change the colors used, and the display. <\/span><\/p>\n<\/div><\/li><\/ol><\/div><style type=\"text\/css\">\n\t.howto_container {\n\t  margin: 0 auto;\n\t}\n\t.howto_container img {\n\t\theight: 100%;\n\t\tmargin-bottom: 30px;\n\t}\n\t\n\t\t  .howto_container h2 {\n\t\t\t  clear: none !important;\n\t\t  }\n\t\t  .howto_container ol {\n\t\t\t  list-style: none !important;\n\t\t  }\t\n\t.howto_container ol li::before {\n\t\tcolor: #ffffff !important;\n\t\tbackground:#0073aa !important;\n\t}\n<\/style>\n\n\t\t\n\n\n<h2 class=\"wp-block-heading\"><strong>Creating Simple Graphs to Represent Data in Excel<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">With Excel, it is simple to create graphs to represent your data visually. Being able to use graphs is great when you need to present information to others as it makes the data easier to understand and visualize.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Using Microsoft Excel on Windows and Mac is becoming one of the best ways to store, manipulate and analyze data. With many different features specifically for data analysis, it is easy to understand why the program is so popular. One of the ways you can present your data is through the use of graphs and &hellip; <a href=\"https:\/\/cms-articles.softonic.io\/en\/how-to-make-a-graph-on-excel-in-4-steps\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;How to Make a Graph on Microsoft Excel in 4 Steps&#8221;<\/span><\/a><\/p>\n","protected":false},"author":9205,"featured_media":181483,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","wpcf-pageviews":9},"categories":[2441],"tags":[2523],"usertag":[],"vertical":[],"content-category":[],"class_list":["post-168564","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to","tag-app-subdomain-redirectionmicrosoft-excel"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts\/168564","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/users\/9205"}],"replies":[{"embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/comments?post=168564"}],"version-history":[{"count":1,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts\/168564\/revisions"}],"predecessor-version":[{"id":324765,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/posts\/168564\/revisions\/324765"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/media\/181483"}],"wp:attachment":[{"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/media?parent=168564"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/categories?post=168564"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/tags?post=168564"},{"taxonomy":"usertag","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/usertag?post=168564"},{"taxonomy":"vertical","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/vertical?post=168564"},{"taxonomy":"content-category","embeddable":true,"href":"https:\/\/cms-articles.softonic.io\/en\/wp-json\/wp\/v2\/content-category?post=168564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}