{"id":16024,"date":"2020-05-15T04:25:27","date_gmt":"2020-05-15T02:25:27","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=16024"},"modified":"2024-04-03T22:07:17","modified_gmt":"2024-04-03T20:07:17","slug":"how-to-make-a-graph-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-make-a-graph-in-excel\/","title":{"rendered":"How to Make a Graph in Excel &#8211; Make Your Data Talk With Visual Charts!"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone size-full wp-image-16663\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/How-to-Make-a-Graph.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"1280\" height=\"720\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/How-to-Make-a-Graph.png 1280w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/How-to-Make-a-Graph-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/How-to-Make-a-Graph-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/How-to-Make-a-Graph-768x432.png 768w\" sizes=\"(max-width: 1280px) 100vw, 1280px\" \/>Most organizations find it challenging to create reports or make decisions by analyzing huge amounts of data spread across various Excel spreadsheets. This is where Excel Graphs comes into action!<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-make-a-graph-in-excel\/#Learning_how_to_make_a_Graph_in_Excel_can_make_your_report_aesthetically_pleasing_and_easy_to_analyze\" title=\"Learning how to make a Graph in Excel can make your report aesthetically pleasing and easy to analyze!\">Learning how to make a Graph in Excel can make your report aesthetically pleasing and easy to analyze!<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-make-a-graph-in-excel\/#How_to_Create_a_Graph_in_Excel\" title=\"How to Create a Graph in Excel\">How to Create a Graph in Excel<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-make-a-graph-in-excel\/#Types_of_Excel_Chart\" title=\"Types of Excel Chart\">Types of Excel Chart<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-make-a-graph-in-excel\/#Customize_an_Excel_chart\" title=\"Customize an Excel chart\">Customize an Excel chart<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-make-a-graph-in-excel\/#Save_as_Chart_Template\" title=\"Save as Chart Template\">Save as Chart Template<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-make-a-graph-in-excel\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Learning_how_to_make_a_Graph_in_Excel_can_make_your_report_aesthetically_pleasing_and_easy_to_analyze\"><\/span>Learning how to make a Graph in Excel can make your report aesthetically pleasing and easy to analyze!<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Graphs can be used to <strong>convert a plethora of rows and columns in Excel into simple charts<\/strong> that are easy to evaluate.<\/p>\n<p>In this step by step tutorial on How to Make a Graph in Excel, you will learn the basics of an Excel Chart, including:<\/p>\n<ul>\n<li><a href=\"#create-a-graph\">How to Create a Graph in Excel<\/a><\/li>\n<li><a href=\"#different-types-of-excel-charts\">Different Types of Excel Charts<\/a><\/li>\n<li><a href=\"#customize-an-excel-chart\">Customize an Excel Chart<\/a><\/li>\n<li><a href=\"#save-chart-as-a-template\">Save Chart as a Template<\/a><\/li>\n<\/ul>\n<p>Make sure to download the exercise workbook to follow along and learn how to make a graph in Excel:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/How-to-Make-Graph-in-Excel.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/How-to-Make-Graph-in-Excel.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">How-to-Make-Graph-in-Excel.xlsx<\/span><\/a><\/p>\n<\/div>\n<div class=\"after-post-box\">\n<p class=\"line-two\">\n<\/div>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/rzR2Z97d16M?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">?<\/span><\/iframe><\/p>\n<div>\n<div style=\"float: left\"><span style=\"text-decoration: underline\"><strong><a href=\"https:\/\/youtu.be\/rzR2Z97d16M\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Watch on YouTube<\/a> <\/strong><\/span>and give it a thumbs up &#x1f44d;<\/div>\n<div>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<h2><\/h2>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"How_to_Create_a_Graph_in_Excel\"><\/span><a id=\"create-a-graph\"><\/a>How to Create a Graph in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-spine-chart\/\" target=\"_blank\" rel=\"noopener\">Excel Charts are visual<\/a> representations of data that are used to make sense to the gazillion amounts of data jammed into rows and columns. It is essenti<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-excel-harvey-balls\/\" target=\"_blank\" rel=\"noopener\">a<\/a>l to learn how to create a graph in Excel if we want to obtain more information from the data. Charts are extremely useful to:<\/p>\n<ul>\n<li>Understand the meaning behind the numbers<\/li>\n<li>Summarize large amounts of data<\/li>\n<li>Draw comparisons between data sets<\/li>\n<li>Spot data outliers that are unrelated to the rest of the data<\/li>\n<li>Identify data trends &amp; patterns<\/li>\n<\/ul>\n<p>You can either work on <strong>existing data stored in Excel<\/strong> or you can <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-external-data-source-create-new-pivot-table\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>import data from other applications<\/strong><\/a>. Just keep in mind that the data should have headers and no blank rows.<\/p>\n<p>In the example below, we have <strong>monthly sales data recorded in Excel<\/strong> and want to know which month achieved the highest and lowest sales:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/sales-data-in-excel-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone wp-image-16027 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/sales-data-in-excel-1.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"334\" height=\"379\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/sales-data-in-excel-1.png 334w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/sales-data-in-excel-1-264x300.png 264w\" sizes=\"(max-width: 334px) 100vw, 334px\" \/><\/a><\/p>\n<p>Below is the <strong>step-by-step tutorial on How to Create a Graph in Excel:<\/strong><\/p>\n<p><strong><span style=\"color: #ff0000\">Step 1:<\/span><\/strong> Select the <strong>range of data<\/strong> (B3: C15) in Excel<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-65-e1588853349304.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone wp-image-16028 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-65-e1588853349304.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"389\" height=\"402\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-65-e1588853349304.png 389w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-65-e1588853349304-290x300.png 290w\" sizes=\"(max-width: 389px) 100vw, 389px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">Step 2:<\/span>\u00a0<\/strong>Go to <strong>Insert Tab<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/insert-tab-in-excel.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone wp-image-16029 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/insert-tab-in-excel.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"947\" height=\"129\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/insert-tab-in-excel.png 947w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/insert-tab-in-excel-300x41.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/insert-tab-in-excel-768x105.png 768w\" sizes=\"(max-width: 947px) 100vw, 947px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>Step 3<\/strong>:<\/span> Under the Charts group, you can <strong>choose from a variety of chart types<\/strong> available or select <strong>Recommended Charts<\/strong>\u00a0to let Excel decide the appropriate chart for your data.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/recommended-charts-in-excel.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone wp-image-16031 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/recommended-charts-in-excel.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"947\" height=\"129\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/recommended-charts-in-excel.png 947w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/recommended-charts-in-excel-300x41.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/recommended-charts-in-excel-768x105.png 768w\" sizes=\"(max-width: 947px) 100vw, 947px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>Step 4:<\/strong> <\/span>The <strong>Insert Chart<\/strong> dialog box will open and from the left panel you can select the chart based on a chart preview. Based on our data, a <strong>clustered column chart<\/strong> will be the most appropriate. So, you can select that and click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/insert-chart-dialog-box-in-excel.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone wp-image-16032 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/insert-chart-dialog-box-in-excel.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"636\" height=\"600\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/insert-chart-dialog-box-in-excel.png 636w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/insert-chart-dialog-box-in-excel-300x283.png 300w\" sizes=\"(max-width: 636px) 100vw, 636px\" \/><\/a><\/p>\n<p>This will cre<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/progress-chart-in-excel\/\" target=\"_blank\" rel=\"noopener\">a<\/a>te a <strong>Graph in Excel<\/strong> with each bar representing a month.<\/p>\n<p>From this visual representation of monthly sales data, you can easily <strong>spot that the highest sales are achieved in July<\/strong> and the <strong>lowest in September<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/column-bar-in-excel-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone wp-image-16336 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/column-bar-in-excel-1.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"946\" height=\"437\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/column-bar-in-excel-1.png 946w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/column-bar-in-excel-1-300x139.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/column-bar-in-excel-1-768x355.png 768w\" sizes=\"(max-width: 946px) 100vw, 946px\" \/><\/a><\/p>\n<p>You can even <strong>update the data<\/strong> used to make your Excel graph.<\/p>\n<p>Let&#8217;s say you want to remove months, <em>November<\/em> and <em>December<\/em>, from the chart created using the step-by-step tutorial on <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/double-bar-graph-in-excel\/\" target=\"_blank\" rel=\"noopener\">how to make a graph<\/a> in Excel above. You can use either of the two methods mentioned below to do so:<\/p>\n<p><span style=\"color: #ff0000\"><strong>Method 1:<\/strong><\/span><\/p>\n<ul>\n<li>Go to <strong>Chart Design<\/strong> Tab and then click on <strong>Select Data<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-66-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone wp-image-16039 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-66-1.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"1180\" height=\"127\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-66-1.png 1180w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-66-1-300x32.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-66-1-1024x110.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-66-1-768x83.png 768w\" sizes=\"(max-width: 1180px) 100vw, 1180px\" \/><\/a><br \/>\n<\/strong><\/li>\n<li>In the<strong> Select Data Source<\/strong> dialog box, under Horizontal Axis Labels, scroll below and un-check November and December.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Select-Data-Source-in-Excel-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone size-full wp-image-16337\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Select-Data-Source-in-Excel-1.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"584\" height=\"324\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Select-Data-Source-in-Excel-1.png 584w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Select-Data-Source-in-Excel-1-300x166.png 300w\" sizes=\"(max-width: 584px) 100vw, 584px\" \/><\/a><\/li>\n<li><strong>Click OK<\/strong>. You will have the edited chart displayed.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/how-to-make-graph-in-excel.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone size-full wp-image-16338\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/how-to-make-graph-in-excel.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"516\" height=\"322\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/how-to-make-graph-in-excel.png 516w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/how-to-make-graph-in-excel-300x187.png 300w\" sizes=\"(max-width: 516px) 100vw, 516px\" \/><\/a><\/li>\n<\/ul>\n<p><span style=\"color: #ff0000\"><strong>Method 2:<\/strong><\/span><\/p>\n<ul>\n<li>Select the chart.<br \/>\n<em>You can see the data used to make a graph are highlighted.<\/em><br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-67.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone wp-image-16042 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-67-e1588878272217.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"1000\" height=\"426\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-67-e1588878272217.png 1000w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-67-e1588878272217-300x128.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-67-e1588878272217-768x327.png 768w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/a><\/li>\n<li>Hover the mouse towards the end of the data table and drag up the data handle to exclude the cells containing data for November and December.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-115.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone size-full wp-image-16340\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-115.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"323\" height=\"377\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-115.png 323w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-115-257x300.png 257w\" sizes=\"(max-width: 323px) 100vw, 323px\" \/><\/a><\/li>\n<li>You will have the edited chart displayed.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/how-to-make-graph-in-excel.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone size-full wp-image-16338\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/how-to-make-graph-in-excel.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"516\" height=\"322\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/how-to-make-graph-in-excel.png 516w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/how-to-make-graph-in-excel-300x187.png 300w\" sizes=\"(max-width: 516px) 100vw, 516px\" \/><\/a><\/li>\n<\/ul>\n<p>Now that you are familiar with <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-add-error-bars-in-excel\/\" target=\"_blank\" rel=\"noopener\">how to make a graph<\/a> in Excel, let&#8217;s move on to the different types of Excel Charts available and their uses.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Types_of_Excel_Chart\"><\/span><a id=\"different-types-of-excel-charts\"><\/a>Types of Excel Chart<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The different types of Excel Charts are elaborately explained here:<\/p>\n<ol>\n<li><strong>Column Chart &#8211; Use this Chart if you have less than 12 data points &amp; want to show trends E.g. Monthly or Annual data points: <\/strong>Column charts are used to visually compare values across a few categories by using vertical bars. In this graph below, each vertical bar represents a month and the vertical axis represents the sales month. This is an example of a Clustered Column chart.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/column-chart-in-excel.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone size-full wp-image-16046\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/column-chart-in-excel.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"502\" height=\"307\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/column-chart-in-excel.png 502w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/column-chart-in-excel-300x183.png 300w\" sizes=\"(max-width: 502px) 100vw, 502px\" \/><\/a><br \/>\n<em><em><em><em><em>Excel offers seven different column chart types: clustered, stacked, 100% stacked, 3-D clustered, 3-D stacked, 3-D 100% stacked, and 3-D.<\/em><\/em><\/em><\/em><\/em><\/li>\n<li><strong>Line Chart &#8211; Use this Chart if you have more than 12 data points &amp; want to show trends E.g. Historic results or Statistical data: <\/strong>Line charts are used to display trends over time. In this graph below, it shows the sales trend over the months. There are 7 different line charts available on Excel &#8211; line, stacked line, 100% stacked line, line with markers, stacked line with markers, 100% stacked line with markers, and 3-D line.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/line-chart-in-excel.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone wp-image-16047 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/line-chart-in-excel.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"504\" height=\"306\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/line-chart-in-excel.png 504w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/line-chart-in-excel-300x182.png 300w\" sizes=\"(max-width: 504px) 100vw, 504px\" \/><\/a><\/li>\n<li><strong>Pie Chart &#8211; Use this Chart for component comparisons only (Sums to 100%) E.g. Market share:<\/strong>\u00a0Pie charts are used to display the contribution of each value (slice) to a total (pie). It can quantify items and show them as a percentage where the total of the numbers is 100%. In this graph below, each pie shows the percentage of sales of a particular month.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/pie-chart-in-excel.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone size-full wp-image-16048\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/pie-chart-in-excel.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"501\" height=\"306\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/pie-chart-in-excel.png 501w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/pie-chart-in-excel-300x183.png 300w\" sizes=\"(max-width: 501px) 100vw, 501px\" \/><\/a><em><em><em><em><em><br \/>\nExcel offers 5 different pie chart types: pie, pie of pie (this breaks out one piece of the pie into another pie to show the sub-category), bar of pie, 3-D pie, and doughnut.<\/em><\/em><\/em><\/em><\/em><\/li>\n<li><strong>Bar Chart &#8211; Use this Chart if you have long names and want to compare E.g. Competitor analysis:<\/strong>\u00a0It is similar to a Column chart but here the constant value is assigned to Y-axis and the variable is assigned to X-axis. In this graph below, each bar represents a sales amount for each month.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/bar-chart-in-excel.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone size-full wp-image-16049\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/bar-chart-in-excel.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"501\" height=\"306\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/bar-chart-in-excel.png 501w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/bar-chart-in-excel-300x183.png 300w\" sizes=\"(max-width: 501px) 100vw, 501px\" \/><\/a><\/li>\n<\/ol>\n<p><em>You can also take a look at this <a href=\"https:\/\/support.office.com\/en-us\/article\/video-create-a-chart-4d95c6a5-42d2-4cfc-aede-0ebf01d409a8\" target=\"_blank\" rel=\"noopener noreferrer\">video by Microsoft<\/a> on how to make a graph in Excel.<\/em><\/p>\n<p>There are other chart types available in Excel like Area Chart, Surface Chart, Radar Chart, Funnel Chart, etc. You can also create a graph called the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/benchmark-chart-in-excel-2013\/\" target=\"_blank\" rel=\"noopener noreferrer\">Combo Chart<\/a> that displays multiple sets of data in different ways on the same chart.<\/p>\n<p>You can even look at <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-chart-helper-infographic\/\" target=\"_blank\" rel=\"noopener noreferrer\">this blog to view our Excel Chart Infographic<\/a>\u00a0 and also learn about the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/charts\/excel-2016-charts\/\" target=\"_blank\" rel=\"noopener noreferrer\">new Excel Charts that were introduced in 2016<\/a>.<\/p>\n<p><em>Now that you have understood How to Make a Graph in Excel and the different types of Excel Charts that are available, it is essential to customize the chart to enhance its appeal.<\/em><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Customize_an_Excel_chart\"><\/span><a id=\"customize-an-excel-chart\"><\/a>Customize an Excel chart<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When you create a graph in Excel and then click on it, you will see two new tabs appearing on the Excel Ribbon &#8211; <strong>Chart Design &amp; Format<\/strong>. These two tabs can be used to customize the chart as per your requirements.<\/p>\n<p><span style=\"color: #ff0000\"><strong>Chart Design Tab &#8211;<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Chart-Desgin-Tab-in-Excel.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone wp-image-16059 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Chart-Desgin-Tab-in-Excel.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"1181\" height=\"139\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Chart-Desgin-Tab-in-Excel.png 1181w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Chart-Desgin-Tab-in-Excel-300x35.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Chart-Desgin-Tab-in-Excel-1024x121.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Chart-Desgin-Tab-in-Excel-768x90.png 768w\" sizes=\"(max-width: 1181px) 100vw, 1181px\" \/><\/a><\/p>\n<p>Chart Design Tab in Excel contains design commands including Chart Layout, Chart Styles, Switch Row\/Column, Select Data, Change Chart Type &amp; Move Chart.<\/p>\n<p><span style=\"color: #ff0000\"><strong>Format Tab &#8211;<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Format-Tab-in-Excel.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone size-full wp-image-16061\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Format-Tab-in-Excel.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"1260\" height=\"129\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Format-Tab-in-Excel.png 1260w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Format-Tab-in-Excel-300x31.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Format-Tab-in-Excel-1024x105.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Format-Tab-in-Excel-768x79.png 768w\" sizes=\"(max-width: 1260px) 100vw, 1260px\" \/><\/a><\/p>\n<p>This ribbon contains format commands like Current Selection, Insert Shape, Shape Styles, WordArt Styles, Arrange Group &amp; Size Group.<\/p>\n<p>You can also click on the chart and access the <strong>Chart Elements button<\/strong> on the upper-right corner of the chart. It contains three options &#8211; <strong>Chart Elements, Chart Style and Chart Filters<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-69.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone size-full wp-image-16064\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-69.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"579\" height=\"359\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-69.png 579w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-69-300x186.png 300w\" sizes=\"(max-width: 579px) 100vw, 579px\" \/><\/a><\/p>\n<p><strong>Chart Element Option (with the + sign icon)<\/strong><\/p>\n<p>Using this option you can customize different chart elements like <strong>Chart Title, Axes, Axis Title, Data Labels, Data Table, Error Bars, Legend, Gridlines, and Trendline<\/strong>.<\/p>\n<p>To <strong>add or remove a chart element, <\/strong>you can simply use the <strong>Chart Element Options<\/strong> and check or un-check the boxes you want to show or hide.<\/p>\n<p>For example, if you have monthly sales data including sales amount and average sales and you can create a column chart using that data.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/How-to-make-a-graph-in-excel-column-chart.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone wp-image-16581 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/How-to-make-a-graph-in-excel-column-chart.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"824\" height=\"396\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/How-to-make-a-graph-in-excel-column-chart.png 824w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/How-to-make-a-graph-in-excel-column-chart-300x144.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/How-to-make-a-graph-in-excel-column-chart-768x369.png 768w\" sizes=\"(max-width: 824px) 100vw, 824px\" \/><\/a><\/p>\n<p>Now if you wish to add a <strong>Legend<\/strong> key<b>\u00a0<\/b>to your chart, follow the steps below:<\/p>\n<p><strong>Step 1:<\/strong> Click on the Chart.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-85.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone size-full wp-image-16138\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-85.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"608\" height=\"371\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-85.png 608w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-85-300x183.png 300w\" sizes=\"(max-width: 608px) 100vw, 608px\" \/><\/a><\/p>\n<p><strong>Step 2:<\/strong> Click on the <strong>+ sign icon<\/strong> to access the Chart Elements Options.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-86.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone size-full wp-image-16139\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-86.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"765\" height=\"371\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-86.png 765w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-86-300x145.png 300w\" sizes=\"(max-width: 765px) 100vw, 765px\" \/><\/a><\/p>\n<p><strong>Step 3:\u00a0<\/strong>Check the box next to <strong>Legend<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-121-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone wp-image-16583 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-121-1.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"739\" height=\"330\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-121-1.png 739w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-121-1-300x134.png 300w\" sizes=\"(max-width: 739px) 100vw, 739px\" \/><\/a><\/p>\n<p>This will add a legend keys next to the chart. To make further customizations like shifting the legend keys to the bottom of the chart: Point to <b class=\"ocpLegacyBold\">Legend, <\/b>select the arrow next to it and select bottom.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-123.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone wp-image-16584 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-123.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"833\" height=\"362\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-123.png 833w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-123-300x130.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-123-768x334.png 768w\" sizes=\"(max-width: 833px) 100vw, 833px\" \/><\/a><\/p>\n<h3>Chart Style<\/h3>\n<p>After you have learned <em>How to Make a Graph in Excel<\/em> and customize the elements, you should move on to making the charts more impactful.\u00a0 You can change the style or color of your chart using this step by step tutorial below:<\/p>\n<p><span style=\"color: #ff0000\"><strong>Step 1:<\/strong><\/span> Click on the chart you want to change<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-89.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone size-full wp-image-16142\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-89.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"567\" height=\"346\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-89.png 567w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-89-300x183.png 300w\" sizes=\"(max-width: 567px) 100vw, 567px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>Step 2:<\/strong> <\/span>Click on the <strong>Brush icon<\/strong> in the upper right corner of the chart<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-90.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone size-full wp-image-16143\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-90.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"814\" height=\"455\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-90.png 814w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-90-300x168.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-90-768x429.png 768w\" sizes=\"(max-width: 814px) 100vw, 814px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">Step 3<\/span>:<\/strong> Click\u00a0<b class=\"ocpUI\">Style <\/b>or <b class=\"ocpUI\">Color<\/b>\u00a0and pick the option you want.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-90-Copy.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone wp-image-16144 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-90-Copy.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"241\" height=\"412\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-90-Copy.png 241w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-90-Copy-175x300.png 175w\" sizes=\"(max-width: 241px) 100vw, 241px\" \/><\/a>\u00a0 \u00a0 \u00a0 \u00a0 <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-91.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone size-full wp-image-16145\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-91.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"257\" height=\"409\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-91.png 257w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-91-189x300.png 189w\" sizes=\"(max-width: 257px) 100vw, 257px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>Step 4:<\/strong><\/span> You can scroll below the different options available and hover over them to get a preview of the styles and colors available and select the one that suits you the best.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-92-e1588979745512.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone size-full wp-image-16146\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-92-e1588979745512.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"542\" height=\"351\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-92-e1588979745512.png 542w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-92-e1588979745512-300x194.png 300w\" sizes=\"(max-width: 542px) 100vw, 542px\" \/><\/a><\/p>\n<p>This is how your edited chart will look like. Pretty cool right? \ud83d\ude42<\/p>\n<p>Learning how to make a graph in Excel is not enough. You can match the style and color of the chart as per your company theme colors, font, and layout.<\/p>\n<h3>Chart Filters<\/h3>\n<p>Ever faced a situation where you want to display only certain data for an Excel Chart. Here is a tutorial on How to Create <strong>Graphs in Excel with Filters<\/strong>. Follow the steps below:<\/p>\n<p><span style=\"color: #ff0000\"><strong>Step 1:<\/strong><\/span> Click anywhere on the chart<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-93-e1589031973178.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone size-full wp-image-16150\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-93-e1589031973178.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"607\" height=\"351\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-93-e1589031973178.png 607w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-93-e1589031973178-300x173.png 300w\" sizes=\"(max-width: 607px) 100vw, 607px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>Step 2<\/strong>:<\/span>\u00a0Click on the<strong> Chart Filter button<\/strong> on the upper right corner of the chart<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-94.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone size-full wp-image-16151\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-94.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"858\" height=\"457\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-94.png 858w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-94-300x160.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-94-768x409.png 768w\" sizes=\"(max-width: 858px) 100vw, 858px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>Step 3:<\/strong><\/span> On the <strong>Values<\/strong> tab, you can<strong> hover the Categories<\/strong> and the corresponding data for that category will be highlighted. In the example below, when you hover over February with your mouse pointer, you can see the bar of February in the Chart being highlighted.\u00a0 Cool!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-95.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone wp-image-16152 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-95-e1589032471506.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"812\" height=\"454\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-95-e1589032471506.png 812w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-95-e1589032471506-300x168.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-95-e1589032471506-768x429.png 768w\" sizes=\"(max-width: 812px) 100vw, 812px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">Step 4:<\/span> <\/strong>To filter the data, you can check or uncheck the series or categories you want to show or hide. In the example below, I have checked the first four months (Jan, Feb, Mar, Apr) and clicked on <strong>Apply<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-96.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone wp-image-16155 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-96-e1589032950851.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"826\" height=\"457\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-96-e1589032950851.png 826w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-96-e1589032950851-300x166.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-96-e1589032950851-768x425.png 768w\" sizes=\"(max-width: 826px) 100vw, 826px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>This will let you filter the data in your Excel Charts and allow you to select the data you want to display or hide.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Save_as_Chart_Template\"><\/span><a id=\"save-chart-as-a-template\"><\/a>Save as Chart Template<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Imagine you have around 20 charts that you want to create in Excel. You went through all the steps mentioned above to add Chart Elements, Customize a Layout and Style, and created an excellent Chart.<\/p>\n<p>Now, are you ready to repeat all these steps for the remaining 19 Charts? Well, you don&#8217;t have to do that.<\/p>\n<p>You can<strong> Save the Chart as <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\" title=\"Template\" data-wpil-keyword-link=\"linked\">Template<\/a><\/strong> and then simply apply that template for the remaining charts. Let us follow the steps below and learn how to create a graph in Excel and save it as a template:<\/p>\n<p><strong><span style=\"color: #ff0000\">Step 1<\/span>:\u00a0Right Click<\/strong> on your perfect Chart<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-97.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone wp-image-16156 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-97-e1589034194879.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"567\" height=\"511\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-97-e1589034194879.png 567w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-97-e1589034194879-300x270.png 300w\" sizes=\"(max-width: 567px) 100vw, 567px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>Step 2:<\/strong> <\/span>Click on <strong>Save as Template<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-99-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone size-full wp-image-16158\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-99-1.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"549\" height=\"396\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-99-1.png 549w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-99-1-300x216.png 300w\" sizes=\"(max-width: 549px) 100vw, 549px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>Step 3:<\/strong> <\/span>In the<strong> Save Chart Template dialog box<\/strong>, give your template a &#8220;name&#8221; and click on <strong>Save.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-101.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone size-full wp-image-16161\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-101.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"670\" height=\"472\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-101.png 670w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-101-300x211.png 300w\" sizes=\"(max-width: 670px) 100vw, 670px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>Step 4:<\/strong> <\/span>Now you move to the next chart where you want to paste this format.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/make-a-graph.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone wp-image-16343\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/make-a-graph.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"551\" height=\"371\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/make-a-graph.png 587w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/make-a-graph-300x202.png 300w\" sizes=\"(max-width: 551px) 100vw, 551px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>Step 5:<\/strong> <\/span><strong>Right-click<\/strong> on that chart and select <strong>Change Chart Type<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-116.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone size-full wp-image-16342\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-116.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"751\" height=\"473\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-116.png 751w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-116-300x189.png 300w\" sizes=\"(max-width: 751px) 100vw, 751px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>Step 6:<\/strong> <\/span>In the <strong>Change Chart Type dialog box<\/strong>, under the <strong>All Charts<\/strong> tab click on <strong><a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\" title=\"Templates\" data-wpil-keyword-link=\"linked\">Templates<\/a><\/strong> and then select the template you have saved. Click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-105.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone size-full wp-image-16164\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-105.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"659\" height=\"603\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-105.png 659w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/Screenshot-105-300x275.png 300w\" sizes=\"(max-width: 659px) 100vw, 659px\" \/><\/a><\/p>\n<p><em>Your second chart will automatically change to the format of your saved template!<\/em><\/p>\n<p>Using the steps mentioned above, you can learn not only how to make a graph in Excel but also how to save the created graph as a template and reuse it whenever you want.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/create-a-graph.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" class=\"alignnone size-full wp-image-16344\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/create-a-graph.png\" alt=\"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!\" width=\"528\" height=\"368\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/create-a-graph.png 528w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/05\/create-a-graph-300x209.png 300w\" sizes=\"(max-width: 528px) 100vw, 528px\" \/><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In this tutorial, you have learned <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/graph-normal-distribution-in-excel\/\" target=\"_blank\" rel=\"noopener\">how to make a graph<\/a> in Excel, the different types of Excel charts, how to customize an Excel Chart, and save a chart as a Template.<\/p>\n<p>You can learn more about <em>How to Make a Graph in Excel<\/em> by viewing our Free Excel tutorials on <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/charts\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel Charts<\/a>!<\/p>\n<p><strong>Make sure to download our FREE PDF on the<a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener noreferrer\"> 333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n<p><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"nofollow noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-14329 size-medium\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-300x200.jpg\" alt=\"\" width=\"300\" height=\"200\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-300x200.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-1024x682.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-768x512.jpg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups.jpg 1340w\" sizes=\"(max-width: 300px) 100vw, 300px\" title=\"\"><\/a><\/p>\n<p><em><strong>You can follow our <a href=\"https:\/\/www.youtube.com\/watch?v=92_CrQRY8Ls&amp;list=PLWSweFpA2PEjn64nnGOwBo2-LoYy4NwTh\" target=\"_blank\" rel=\"noopener noreferrer\">YouTube channel<\/a> to learn more about How To Create a Graph in Excel!<\/strong><\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Most organizations find it challenging to create reports or make decisions by analyzing huge amounts of data spread across various Excel spreadsheets. This is where Excel Graphs comes into action! Learning how to make a Graph in Excel can make your report aesthetically pleasing and easy to analyze! Graphs can be used to convert a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":16663,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[5],"tags":[632,631,627,626,628,629,630],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/16024"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=16024"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/16024\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/16663"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=16024"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=16024"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=16024"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}