{"id":16176,"date":"2024-11-27T06:52:39","date_gmt":"2024-11-27T06:52:39","guid":{"rendered":"https:\/\/www.pickl.ai\/blog\/?p=16176"},"modified":"2024-11-27T06:52:40","modified_gmt":"2024-11-27T06:52:40","slug":"how-do-you-make-and-plot-graph-in-excel","status":"publish","type":"post","link":"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/","title":{"rendered":"How Do You Make and Plot Graphs in Excel?"},"content":{"rendered":"\n<p><strong>Summary:<\/strong> This blog provides a comprehensive guide on how to make and plot graphs in Excel, covering various graph types, data preparation, and customisation techniques. It emphasises the importance of effective data visualisation for clearly communicating trends and insights, ensuring users can easily create informative charts.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Introduction\" >Introduction<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Understanding_the_Types_of_Graphs_in_Excel\" >Understanding the Types of Graphs in Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Line_Graph\" >Line Graph<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Bar_Chart\" >Bar Chart<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Pie_Chart\" >Pie Chart<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Scatter_Plot\" >Scatter Plot<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Area_Chart\" >Area Chart<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Other_Types\" >Other Types<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Preparing_Your_Data\" >Preparing Your Data<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Organising_Data_in_Rows_and_Columns\" >Organising Data in Rows and Columns<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Ensuring_Data_Consistency_for_Better_Graphing\" >Ensuring Data Consistency for Better Graphing<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Highlighting_Key_Data_for_Graph_Creation\" >Highlighting Key Data for Graph Creation<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#How_to_Create_a_Basic_Graph_in_Excel\" >How to Create a Basic Graph in Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Step_1_Organise_Your_Data\" >Step 1: Organise Your Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Step_2_Select_the_Data_Range\" >Step 2: Select the Data Range<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Step_3_Insert_a_Graph_via_the_Ribbon\" >Step 3: Insert a Graph via the Ribbon<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Customising_Graphs\" >Customising Graphs<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Changing_Chart_Styles_and_Colours\" >Changing Chart Styles and Colours<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Adjusting_Axis_Labels_and_Titles\" >Adjusting Axis Labels and Titles<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Modifying_Legends_and_Gridlines\" >Modifying Legends and Gridlines<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Adding_Data_Labels\" >Adding Data Labels<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Advanced_Graph_Features\" >Advanced Graph Features<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Adding_Secondary_Axes\" >Adding Secondary Axes<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Creating_Combo_Charts\" >Creating Combo Charts<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Using_Trendlines_and_Error_Bars\" >Using Trendlines and Error Bars<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Creating_Dynamic_Graphs_Using_PivotTables\" >Creating Dynamic Graphs Using PivotTables<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Tips_for_Effective_Data_Visualisation\" >Tips for Effective Data Visualisation<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-28\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Choosing_the_Right_Graph_for_Your_Data\" >Choosing the Right Graph for Your Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-29\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Avoiding_Common_Mistakes_in_Graph_Creation\" >Avoiding Common Mistakes in Graph Creation<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-30\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Making_Your_Graph_More_Readable\" >Making Your Graph More Readable<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-31\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Bottom_Line\" >Bottom Line<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-32\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Frequently_Asked_Questions\" >Frequently Asked Questions<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-33\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#What_Types_of_Graphs_Can_I_Create_in_Excel\" >What Types of Graphs Can I Create in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-34\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#How_do_I_Prepare_My_Data_for_Graphing_in_Excel\" >How do I Prepare My Data for Graphing in Excel?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-35\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#Can_I_Customise_My_Graphs_in_Excel\" >Can I Customise My Graphs in Excel?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 id=\"introduction\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Introduction\"><\/span><strong>Introduction<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Visual <a href=\"https:\/\/pickl.ai\/blog\/round-off-formula-in-excel\/\">data representation<\/a> is crucial for understanding trends, patterns, and insights in today&#8217;s data-driven world. Graphs make complex data accessible, allowing quick decision-making. This blog will teach you how to make and plot graphs in Excel, empowering you to create clear, informative charts.&nbsp;<\/p>\n\n\n\n<p>Excel is a top choice for graphing due to its versatility, ease of use, and wide range of chart options. With a market share of <a href=\"https:\/\/www.6sense.com\/tech\/productivity\/microsoft-excel-market-share\">10.15%<\/a> in the productivity market and <a href=\"https:\/\/www.6sense.com\/tech\/document-management\/microsoft-excel-market-share\">2.95%<\/a> in document management, Microsoft Excel remains a go-to tool for professionals across industries, ensuring effective data analysis and presentation.<\/p>\n\n\n\n<p><strong>Key Takeaways<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Choose the right graph type based on your data&#8217;s story.<\/li>\n\n\n\n<li>Organise data clearly in rows and columns for accuracy.<\/li>\n\n\n\n<li>Customise graphs for better readability and presentation.<\/li>\n\n\n\n<li>Utilise advanced features like combo charts and secondary axes.<\/li>\n\n\n\n<li>Follow best practices to avoid common graphing mistakes.<\/li>\n<\/ul>\n\n\n\n<h2 id=\"understanding-the-types-of-graphs-in-excel\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Understanding_the_Types_of_Graphs_in_Excel\"><\/span><strong>Understanding the Types of Graphs in Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>When working with <a href=\"https:\/\/pickl.ai\/blog\/use-of-excel-in-data-analysis\/\">data in Excel<\/a>, choosing the right type of graph is essential to communicate your information. Excel offers a variety of graph types, each suited to <a href=\"https:\/\/pickl.ai\/blog\/why-is-data-visualization-important\/\">different data visualisation needs<\/a>.&nbsp;<\/p>\n\n\n\n<p>Understanding the purpose of each graph type helps you present data in the most meaningful way. Below are the most common graph types and when to use them.<\/p>\n\n\n\n<h3 id=\"line-graph\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Line_Graph\"><\/span><strong>Line Graph<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Line graphs are ideal for showing trends over time. They connect data points with a line, making them great for visualising value changes over continuous periods, such as months, years, or hours. Line graphs often display stock market trends, sales growth, or temperature fluctuations.<\/p>\n\n\n\n<h3 id=\"bar-chart\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Bar_Chart\"><\/span><strong>Bar Chart<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Bar charts use rectangular bars to represent data. The length of the bar corresponds to the value it represents, making bar charts useful for comparing different categories. These charts are most effective when comparing distinct groups, such as sales performance by region or product comparisons.<\/p>\n\n\n\n<h3 id=\"pie-chart\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Pie_Chart\"><\/span><strong>Pie Chart<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Pie charts display data as slices of a circle, showing the proportion of each category concerning the whole. This chart type is useful for demonstrating relative percentages. Use a pie chart to highlight how individual components make up a total, such as market share or survey results.<\/p>\n\n\n\n<h3 id=\"scatter-plot\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Scatter_Plot\"><\/span><strong>Scatter Plot<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Scatter plots use dots to represent values on two axes, helping to identify relationships or patterns between variables. This chart type is commonly used for statistical analysis, showing correlations such as the relationship between advertising spend and sales performance.<\/p>\n\n\n\n<h3 id=\"area-chart\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Area_Chart\"><\/span><strong>Area Chart<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Area charts are similar to line graphs but fill the area beneath the line with colour. This chart type is useful for visualising the cumulative magnitude of trends over time. It\u2019s often used to show the total value of multiple data series and how each contributes to the total.<\/p>\n\n\n\n<h3 id=\"other-types\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Other_Types\"><\/span><strong>Other Types<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Excel offers many other graph types, such as column charts and histograms. Column charts are like bar charts but with vertical bars, and histograms display data distribution across specified intervals. These graphs are ideal for visualising frequency distributions or comparing categories differently.<\/p>\n\n\n\n<h2 id=\"preparing-your-data\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Preparing_Your_Data\"><\/span><strong>Preparing Your Data<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXctLIQ2b4kA-OpffqBxvgkwiOIS6dU03J199EU8PA6ghvrtMh-FrgK2_4GY-5zUB5cZFhWrtLhYY01dw6UDB9XcmeeNuGVh-4Y6jIkFfoXKD0geFnqJbn3udjVzKWpCduapZwNw?key=B7mAKhBH-FF_txSoYhGt0gS-\" alt=\"Organising data in Excel for accurate graph creation.\"\/><\/figure>\n\n\n\n<p>Before you can start creating graphs in Excel, properly organising your data is crucial. A well-organised dataset makes the graph creation process smoother and ensures that your graphs are accurate and easy to interpret. Here&#8217;s how to prepare your data for graphing:<\/p>\n\n\n\n<h3 id=\"organising-data-in-rows-and-columns\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Organising_Data_in_Rows_and_Columns\"><\/span><strong>Organising Data in Rows and Columns<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The first step in preparing your data is to arrange it in a logical format. Excel uses rows and columns to organise data, with each row representing a record and each column representing a variable or category.&nbsp;<\/p>\n\n\n\n<p>For example, if you plot sales data over months, list the months in one column and the sales figures in the next column.<\/p>\n\n\n\n<p>Ensure that your data is well-structured by using clear headings for each column. This will help Excel recognise the data&#8217;s relationship when you create your graph. Also, avoid leaving blank cells in your dataset, which can lead to errors when plotting your graph.<\/p>\n\n\n\n<h3 id=\"ensuring-data-consistency-for-better-graphing\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ensuring_Data_Consistency_for_Better_Graphing\"><\/span><strong>Ensuring Data Consistency for Better Graphing<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Data consistency is key when preparing to plot graphs. All values within a column should follow the same format. For example, if you&#8217;re working with dates, ensure all date entries are in the same format. If you plot numerical data, ensure that units (e.g., dollars, kilograms) are consistent throughout.<\/p>\n\n\n\n<p>Inconsistent data can result in misleading graphs or errors. Double-check for outliers, missing values, or data entries that don&#8217;t match the rest. Excel\u2019s built-in functions like &#8220;Find &amp; Replace&#8221; can help spot and correct inconsistencies quickly.<\/p>\n\n\n\n<h3 id=\"highlighting-key-data-for-graph-creation\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Highlighting_Key_Data_for_Graph_Creation\"><\/span><strong>Highlighting Key Data for Graph Creation<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Once your data is organised and consistent, highlight the key information you want to graph. Select the data range that includes the variables you need for your graph, such as the periods and the corresponding values.&nbsp;<\/p>\n\n\n\n<p>Include any labels or headings, as these will be used as chart titles and axis labels in your final graph.<\/p>\n\n\n\n<p>Highlighting the relevant data ensures that Excel only graphs what you need, preventing unnecessary data from cluttering the chart and making it harder to interpret.<\/p>\n\n\n\n<h2 id=\"how-to-create-a-basic-graph-in-excel\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_Create_a_Basic_Graph_in_Excel\"><\/span><strong>How to Create a Basic Graph in Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Creating a basic graph in Excel is straightforward, and with just a few steps, you can turn your raw data into a clear visual representation. In this section, we\u2019ll walk through the process of selecting data, inserting a chart, and customising it for clarity and ease of understanding.<\/p>\n\n\n\n<h3 id=\"step-1-organise-your-data\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_1_Organise_Your_Data\"><\/span><strong>Step 1: Organise Your Data<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Before you can create a graph, ensure your data is structured correctly. Typically, data should be organised in rows and columns. Each column or row should represent a category (e.g., months, product names, or regions), and each data point should align with these categories.&nbsp;<\/p>\n\n\n\n<p>For example, when plotting monthly sales, place the months in one column and the sales figures in the adjacent column.<\/p>\n\n\n\n<p>Excel automatically detects the structure of your data, so ensuring it\u2019s adequately formatted is key to creating an accurate graph.<\/p>\n\n\n\n<h3 id=\"step-2-select-the-data-range\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_2_Select_the_Data_Range\"><\/span><strong>Step 2: Select the Data Range<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Now, highlight the data you want to include in your graph. This can be done by clicking and dragging over your data&#8217;s cells. Select the categories (e.g., months or product names) and the numerical values (e.g., sales or quantities).&nbsp;<\/p>\n\n\n\n<p>For example, if you plot monthly sales for a year, select the entire range of months and sales figures.<\/p>\n\n\n\n<p>Selecting the correct data range is crucial because Excel uses this range to plot the graph. The graph may not display as expected if your selection is too large or too small.<\/p>\n\n\n\n<h3 id=\"step-3-insert-a-graph-via-the-ribbon\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step_3_Insert_a_Graph_via_the_Ribbon\"><\/span><strong>Step 3: Insert a Graph via the Ribbon<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>With your data selected, it\u2019s time to insert a graph. Here\u2019s how to do it:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Go to the Ribbon<\/strong>: In Excel, the Ribbon is at the top of the screen and contains all the necessary commands. Click on the <strong>Insert<\/strong> tab.<\/li>\n\n\n\n<li><strong>Choose a Chart Type<\/strong>: Within the Insert tab, you will see several options under the <strong>Charts<\/strong> section. Common choices for basic graphs include:\n<ul class=\"wp-block-list\">\n<li><strong>Bar Chart<\/strong>: Ideal for comparing quantities across different categories.<\/li>\n\n\n\n<li><strong>Line Chart<\/strong>: Perfect for showing trends over time.<\/li>\n\n\n\n<li><strong>Column Chart<\/strong>: Great for visualising data across categories.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Select the Chart Style<\/strong>: Click on the desired chart type (e.g., Bar Chart), and a <a href=\"https:\/\/pickl.ai\/blog\/drop-down-list-in-excel\/\">drop-down<\/a> menu will show different styles. Choose the one that best fits your data and visual preference.<\/li>\n\n\n\n<li><strong>Insert the Chart<\/strong>: After selecting the style, click on it, and Excel will automatically generate the graph based on your data selection.<\/li>\n<\/ul>\n\n\n\n<p>Once the chart appears, it will be embedded directly into your worksheet, ready for further customisation.<\/p>\n\n\n\n<h2 id=\"customising-graphs\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Customising_Graphs\"><\/span><strong>Customising Graphs<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXfRg8ske_BO-7T0Gex0QxLi1qUMmbmM3-i-2ElvmDI8ck5WSyjZfgN8qk0PrNYE2FTEQwKtl8I4qYP065EFn9HarZ6fPV8EiuIA05I3Md4ysVZ3kRud1Pnjg0N3jmyxRdOz_jUSEw?key=B7mAKhBH-FF_txSoYhGt0gS-\" alt=\"Customising a graph in Excel with various options.\"\/><\/figure>\n\n\n\n<p>Once you\u2019ve created a graph in Excel, the next step is customising it to represent your data better and make it more visually appealing. Customisation options allow you to adjust various elements of your graph to suit your presentation style or the specific information you want to highlight.&nbsp;<\/p>\n\n\n\n<p>Here are some common ways to modify your graph in Excel.<\/p>\n\n\n\n<h3 id=\"changing-chart-styles-and-colours\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Changing_Chart_Styles_and_Colours\"><\/span><strong>Changing Chart Styles and Colours<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Excel provides a wide range of chart styles and colour palettes to help enhance the look of your graph. To change the chart style, click on the chart to activate the \u201cChart Tools\u201d section in the ribbon. Then, under the &#8220;Design&#8221; tab, you\u2019ll find options for different chart styles and colour schemes.&nbsp;<\/p>\n\n\n\n<p>Select a pre-set style that adjusts the layout, colours, and overall design to suit your data. Alternatively, click &#8220;Change Colors&#8221; to choose a custom colour palette for your graph elements, such as the bars, lines, or slices.<\/p>\n\n\n\n<h3 id=\"adjusting-axis-labels-and-titles\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Adjusting_Axis_Labels_and_Titles\"><\/span><strong>Adjusting Axis Labels and Titles<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Axis labels and titles are crucial for making your graph easy to understand. To add or adjust these labels, click on the chart, then navigate to the &#8220;Chart Elements&#8221; button (the plus sign icon) on the right side.&nbsp;<\/p>\n\n\n\n<p>You can toggle the &#8220;Axis Titles&#8221; <a href=\"https:\/\/pickl.ai\/blog\/insert-checkbox-in-excel\/\">checkbox<\/a> to add titles for both the X and Y axes. Once the titles appear, simply click on them to edit the text. Ensure the titles clearly describe the variables represented by each axis.<\/p>\n\n\n\n<p>For the chart title, click on the default title and change it to a more meaningful one that describes the graph\u2019s content. Using the &#8220;Home&#8221; tab in the ribbon, you can further format these titles by adjusting the font size, style, and alignment.<\/p>\n\n\n\n<h3 id=\"modifying-legends-and-gridlines\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Modifying_Legends_and_Gridlines\"><\/span><strong>Modifying Legends and Gridlines<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Legends and gridlines provide context to your chart, making it easier to interpret. To modify the legend, click on the chart and use the \u201cChart Elements\u201d button to toggle the &#8220;Legend&#8221; on or off. For better placement, you can also choose its position (top, bottom, right, or left).<\/p>\n\n\n\n<p>Gridlines help to align data points with axis values visually. To adjust the gridlines, click the chart, go to the \u201cChart Elements\u201d button, and check or uncheck the \u201cGridlines\u201d box. You can choose to show major or minor gridlines or even customise the appearance of gridlines by right-clicking on them and selecting &#8220;Format Gridlines.&#8221;<\/p>\n\n\n\n<h3 id=\"adding-data-labels\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Adding_Data_Labels\"><\/span><strong>Adding Data Labels<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Data labels are a great way to display specific values directly on your chart, making it easier for your audience to see the exact figures. To add data labels, click on the chart, go to the &#8220;Chart Elements&#8221; button, and select &#8220;Data Labels.&#8221;&nbsp;<\/p>\n\n\n\n<p>Depending on your design preference, you can choose to display labels inside or outside the chart. For further customisation, you can format the labels by changing the font style, size, or number format to make them more readable.<\/p>\n\n\n\n<p>Using these customisation features, you can create a more professional and informative graph highlighting key data points and making your chart easier to understand.<\/p>\n\n\n\n<h2 id=\"advanced-graph-features\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Advanced_Graph_Features\"><\/span><strong>Advanced Graph Features<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>When you\u2019ve mastered the basics of creating graphs in Excel, it\u2019s time to explore advanced features that can make your visualisations more dynamic and informative. These features allow you to present complex data better, compare multiple variables, and highlight key insights. In this section, we\u2019ll look at some powerful tools that will enhance your graphing capabilities.<\/p>\n\n\n\n<h3 id=\"adding-secondary-axes\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Adding_Secondary_Axes\"><\/span><strong>Adding Secondary Axes<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Sometimes, you may want to compare two data sets with vastly different ranges in the same chart. This is where secondary axes come in handy. By adding a secondary axis to your graph, you can display two sets of data with varying scales of value.<\/p>\n\n\n\n<p>To add a secondary axis:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create your chart.<\/li>\n\n\n\n<li>Right-click on the data series you want to move to the secondary axis.<\/li>\n\n\n\n<li>Select \u201cFormat Data Series\u201d and check the box for \u201cSecondary Axis.\u201d<\/li>\n<\/ul>\n\n\n\n<p>This is especially useful when comparing data points like sales and temperature, where the scales are vastly different but need to be visualised together. The secondary axis helps ensure each dataset is represented accurately and clearly.<\/p>\n\n\n\n<h3 id=\"creating-combo-charts\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Creating_Combo_Charts\"><\/span><strong>Creating Combo Charts<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>A combo chart allows you to combine different charts, like a bar chart and a line chart, into one. This is useful when highlighting relationships between multiple variables that behave differently. For example, you might use a bar chart for sales figures and a line chart to show trends over time.<\/p>\n\n\n\n<p>To create a combo chart:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select the data for your chart.<\/li>\n\n\n\n<li>Go to the &#8220;Insert&#8221; tab and choose \u201cCombo Chart\u201d from the Chart options.<\/li>\n\n\n\n<li>Choose the chart types for each data series.<\/li>\n<\/ul>\n\n\n\n<p>Combo charts help create visually appealing graphs that display the correlation between data sets.<\/p>\n\n\n\n<h3 id=\"using-trendlines-and-error-bars\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Using_Trendlines_and_Error_Bars\"><\/span><strong>Using Trendlines and Error Bars<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Trendlines and error bars are essential for analysing data trends and showing variability. Trendlines help you identify patterns in your data, such as upward or downward trends, and can be applied to line, scatter, or bar charts. Error bars, on the other hand, show the variability or uncertainty in your data points.<\/p>\n\n\n\n<p>To add a trendline:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on a data point in your chart.<\/li>\n\n\n\n<li>Right-click and select \u201cAdd Trendline.\u201d<\/li>\n\n\n\n<li>Choose the type of trendline (linear, exponential, etc.) that best fits your data.<\/li>\n<\/ul>\n\n\n\n<p>Error bars are similarly easy to add by selecting the \u201cError Bars\u201d option from the \u201cChart Elements\u201d menu.<\/p>\n\n\n\n<h3 id=\"creating-dynamic-graphs-using-pivottables\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Creating_Dynamic_Graphs_Using_PivotTables\"><\/span><strong>Creating Dynamic Graphs Using PivotTables<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Dynamic graphs are perfect when updating your charts based on changing data. <a href=\"https:\/\/pickl.ai\/blog\/learn-how-to-make-and-use-pivot-table-in-excel\/\">PivotTable<\/a>s are a powerful way to summarise and analyse large datasets, and when combined with charts, they create dynamic, interactive visuals.<\/p>\n\n\n\n<p>To create a dynamic graph:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Insert a PivotTable to summarise your data.<\/li>\n\n\n\n<li>Create a chart based on the PivotTable.<\/li>\n\n\n\n<li>As you update the PivotTable (filter, sort, or add new data), the chart will automatically adjust.<\/li>\n<\/ul>\n\n\n\n<p>Dynamic graphs enable you to track and analyse trends in real time without manually adjusting your chart each time the data changes.<\/p>\n\n\n\n<p>By mastering these advanced graph features, you can create more sophisticated and <a href=\"https:\/\/pickl.ai\/blog\/how-is-data-visualization-helpful-in-business-analytics\/\">insightful visualisations<\/a>, which will help you better understand and communicate your data.<\/p>\n\n\n\n<h2 id=\"tips-for-effective-data-visualisation\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Tips_for_Effective_Data_Visualisation\"><\/span><strong>Tips for Effective Data Visualisation<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXesWj4IMP6dpQJPtYh9Yo0U1W_YagVX1qwecCFKdGvPcsXtY0SGqFJg9saZy9ivRFaP20SMfDPRadLmXjvjZbQQWUDXCjuVriRSpLm7Z4UMkAUQv8ZZ6LxuGDLWkmvx3Yuc3e8I?key=B7mAKhBH-FF_txSoYhGt0gS-\" alt=\"Tips for effective data visualisation with key strategies.\"\/><\/figure>\n\n\n\n<p>Creating effective data visualisations goes beyond simply plotting graphs in Excel. The goal is to convey information clearly and engagingly. Here are some essential tips to ensure your charts deliver the right message.<\/p>\n\n\n\n<h3 id=\"choosing-the-right-graph-for-your-data\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Choosing_the_Right_Graph_for_Your_Data\"><\/span><strong>Choosing the Right Graph for Your Data<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The first step in creating an effective graph is selecting the right type. Different datasets require <a href=\"https:\/\/pickl.ai\/blog\/types-of-data-visualization\/\">different visualisations<\/a>. A line graph or area chart is often best for time-based data, as it shows trends over time.<\/p>\n\n\n\n<p>If comparing quantities across categories, opt for a bar or column chart. A pie chart works well for percentages or parts of a whole. Scatter plots are ideal for showing relationships between variables. Always <a href=\"https:\/\/pickl.ai\/blog\/advanced-excel-chart-types\/\">match the chart type<\/a> to the data&#8217;s story to clarify your insights.<\/p>\n\n\n\n<h3 id=\"avoiding-common-mistakes-in-graph-creation\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Avoiding_Common_Mistakes_in_Graph_Creation\"><\/span><strong>Avoiding Common Mistakes in Graph Creation<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Many graphs become ineffective due to common mistakes. One common error is overloading the graph with too much information. Limit the number of data points or categories displayed to keep your data concise and avoid clutter.&nbsp;<\/p>\n\n\n\n<p>Another mistake is misleading axis scales\u2014ensure that your axis starts at zero or adjust it appropriately to avoid distorting the data\u2019s message. Inconsistent labelling is problematic, so use clear and consistent titles, axis labels, and legends.&nbsp;<\/p>\n\n\n\n<p>Lastly, avoid using too many colours, as it can make your graph look chaotic and more challenging to interpret.<\/p>\n\n\n\n<h3 id=\"making-your-graph-more-readable\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Making_Your_Graph_More_Readable\"><\/span><strong>Making Your Graph More Readable<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>A clear graph is easy to read at a glance. To achieve this, focus on font sizes and colour contrast. Use a larger font for titles and axis labels, and choose legible, professional fonts.&nbsp;<\/p>\n\n\n\n<p>Stick to a maximum of two or three colours for clarity. Ensure that the colours contrast well so the data stands out, especially when presenting in a crowded setting.&nbsp;<\/p>\n\n\n\n<p>Avoid using colours that may be hard to distinguish for those with colour vision deficiencies. When appropriate, use bold or italic text to emphasise key points.<\/p>\n\n\n\n<p>By following these tips, you can create more effective, visually appealing graphs that enhance the clarity of your data.<\/p>\n\n\n\n<h2 id=\"bottom-line\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Bottom_Line\"><\/span><strong>Bottom Line<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Creating and plotting graphs in Excel is essential for effective data visualisation. By understanding various graph types and mastering the tools available in Excel, users can transform raw data into clear, informative visuals. This skill enhances data analysis and presentation, making it easier to communicate insights and trends.<\/p>\n\n\n\n<h2 id=\"frequently-asked-questions\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Frequently_Asked_Questions\"><\/span><strong>Frequently Asked Questions<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 id=\"what-types-of-graphs-can-i-create-in-excel\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_Types_of_Graphs_Can_I_Create_in_Excel\"><\/span><strong>What Types of Graphs Can I Create in Excel?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Excel offers various graph types, including line graphs, bar charts, pie charts, scatter plots, and area charts. Each type serves different visualisation needs, such as showing trends or comparing categories.<\/p>\n\n\n\n<h3 id=\"how-do-i-prepare-my-data-for-graphing-in-excel\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_do_I_Prepare_My_Data_for_Graphing_in_Excel\"><\/span><strong>How do I Prepare My Data for Graphing in Excel?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Organise your data in rows and columns with clear headings. Ensure consistency in data formats and avoid blank cells to facilitate accurate graph creation.<\/p>\n\n\n\n<h3 id=\"can-i-customise-my-graphs-in-excel\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Can_I_Customise_My_Graphs_in_Excel\"><\/span><strong>Can I Customise My Graphs in Excel?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Yes, Excel allows extensive customisation options. You can change chart styles, colours, axis labels, and titles and add data labels to enhance clarity and presentation.<\/p>\n","protected":false},"excerpt":{"rendered":"Master how to make and plot graphs in Excel for impactful data analysis and visualisation.\n","protected":false},"author":27,"featured_media":16177,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2318],"tags":[3501],"ppma_author":[2217,2631],"class_list":{"0":"post-16176","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel","8":"tag-plot-graphs-in-excel"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How Do You Make and Plot Graph in Excel?<\/title>\n<meta name=\"description\" content=\"Learn how to make and plot graph in Excel effectively with our comprehensive guide on graph types and customisation techniques.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Do You Make and Plot Graphs in Excel?\" \/>\n<meta property=\"og:description\" content=\"Learn how to make and plot graph in Excel effectively with our comprehensive guide on graph types and customisation techniques.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Pickl.AI\" \/>\n<meta property=\"article:published_time\" content=\"2024-11-27T06:52:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-27T06:52:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/11\/image4-4.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Julie Bowie, Kajal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Julie Bowie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"13 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/how-do-you-make-and-plot-graph-in-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/how-do-you-make-and-plot-graph-in-excel\\\/\"},\"author\":{\"name\":\"Julie Bowie\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/c4ff9404600a51d9924b7d4356505a40\"},\"headline\":\"How Do You Make and Plot Graphs in Excel?\",\"datePublished\":\"2024-11-27T06:52:39+00:00\",\"dateModified\":\"2024-11-27T06:52:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/how-do-you-make-and-plot-graph-in-excel\\\/\"},\"wordCount\":2805,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/how-do-you-make-and-plot-graph-in-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/image4-4.jpg\",\"keywords\":[\"Plot Graphs in Excel\"],\"articleSection\":[\"Excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/how-do-you-make-and-plot-graph-in-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/how-do-you-make-and-plot-graph-in-excel\\\/\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/how-do-you-make-and-plot-graph-in-excel\\\/\",\"name\":\"How Do You Make and Plot Graph in Excel?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/how-do-you-make-and-plot-graph-in-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/how-do-you-make-and-plot-graph-in-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/image4-4.jpg\",\"datePublished\":\"2024-11-27T06:52:39+00:00\",\"dateModified\":\"2024-11-27T06:52:40+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/c4ff9404600a51d9924b7d4356505a40\"},\"description\":\"Learn how to make and plot graph in Excel effectively with our comprehensive guide on graph types and customisation techniques.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/how-do-you-make-and-plot-graph-in-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/how-do-you-make-and-plot-graph-in-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/how-do-you-make-and-plot-graph-in-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/image4-4.jpg\",\"contentUrl\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/image4-4.jpg\",\"width\":1200,\"height\":628,\"caption\":\"How Do You Make and Plot Graphs in Excel?\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/how-do-you-make-and-plot-graph-in-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel\",\"item\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/category\\\/excel\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How Do You Make and Plot Graphs in Excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/\",\"name\":\"Pickl.AI\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/#\\\/schema\\\/person\\\/c4ff9404600a51d9924b7d4356505a40\",\"name\":\"Julie Bowie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/317b68e296bf24b015e618e1fb1fc49f6d8b138bb9cf93c16da2194964636c7d?s=96&d=mm&r=g6d567bb101286f6a3fd640329347e093\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/317b68e296bf24b015e618e1fb1fc49f6d8b138bb9cf93c16da2194964636c7d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/317b68e296bf24b015e618e1fb1fc49f6d8b138bb9cf93c16da2194964636c7d?s=96&d=mm&r=g\",\"caption\":\"Julie Bowie\"},\"description\":\"I am Julie Bowie a data scientist with a specialization in machine learning. I have conducted research in the field of language processing and has published several papers in reputable journals.\",\"url\":\"https:\\\/\\\/www.pickl.ai\\\/blog\\\/author\\\/juliebowie\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How Do You Make and Plot Graph in Excel?","description":"Learn how to make and plot graph in Excel effectively with our comprehensive guide on graph types and customisation techniques.","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:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"How Do You Make and Plot Graphs in Excel?","og_description":"Learn how to make and plot graph in Excel effectively with our comprehensive guide on graph types and customisation techniques.","og_url":"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/","og_site_name":"Pickl.AI","article_published_time":"2024-11-27T06:52:39+00:00","article_modified_time":"2024-11-27T06:52:40+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/11\/image4-4.jpg","type":"image\/jpeg"}],"author":"Julie Bowie, Kajal","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Julie Bowie","Est. reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/"},"author":{"name":"Julie Bowie","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/c4ff9404600a51d9924b7d4356505a40"},"headline":"How Do You Make and Plot Graphs in Excel?","datePublished":"2024-11-27T06:52:39+00:00","dateModified":"2024-11-27T06:52:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/"},"wordCount":2805,"commentCount":0,"image":{"@id":"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/11\/image4-4.jpg","keywords":["Plot Graphs in Excel"],"articleSection":["Excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/","url":"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/","name":"How Do You Make and Plot Graph in Excel?","isPartOf":{"@id":"https:\/\/www.pickl.ai\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/11\/image4-4.jpg","datePublished":"2024-11-27T06:52:39+00:00","dateModified":"2024-11-27T06:52:40+00:00","author":{"@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/c4ff9404600a51d9924b7d4356505a40"},"description":"Learn how to make and plot graph in Excel effectively with our comprehensive guide on graph types and customisation techniques.","breadcrumb":{"@id":"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#primaryimage","url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/11\/image4-4.jpg","contentUrl":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/11\/image4-4.jpg","width":1200,"height":628,"caption":"How Do You Make and Plot Graphs in Excel?"},{"@type":"BreadcrumbList","@id":"https:\/\/www.pickl.ai\/blog\/how-do-you-make-and-plot-graph-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pickl.ai\/blog\/"},{"@type":"ListItem","position":2,"name":"Excel","item":"https:\/\/www.pickl.ai\/blog\/category\/excel\/"},{"@type":"ListItem","position":3,"name":"How Do You Make and Plot Graphs in Excel?"}]},{"@type":"WebSite","@id":"https:\/\/www.pickl.ai\/blog\/#website","url":"https:\/\/www.pickl.ai\/blog\/","name":"Pickl.AI","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pickl.ai\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.pickl.ai\/blog\/#\/schema\/person\/c4ff9404600a51d9924b7d4356505a40","name":"Julie Bowie","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/317b68e296bf24b015e618e1fb1fc49f6d8b138bb9cf93c16da2194964636c7d?s=96&d=mm&r=g6d567bb101286f6a3fd640329347e093","url":"https:\/\/secure.gravatar.com\/avatar\/317b68e296bf24b015e618e1fb1fc49f6d8b138bb9cf93c16da2194964636c7d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/317b68e296bf24b015e618e1fb1fc49f6d8b138bb9cf93c16da2194964636c7d?s=96&d=mm&r=g","caption":"Julie Bowie"},"description":"I am Julie Bowie a data scientist with a specialization in machine learning. I have conducted research in the field of language processing and has published several papers in reputable journals.","url":"https:\/\/www.pickl.ai\/blog\/author\/juliebowie\/"}]}},"jetpack_featured_media_url":"https:\/\/www.pickl.ai\/blog\/wp-content\/uploads\/2024\/11\/image4-4.jpg","authors":[{"term_id":2217,"user_id":27,"is_guest":0,"slug":"juliebowie","display_name":"Julie Bowie","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/317b68e296bf24b015e618e1fb1fc49f6d8b138bb9cf93c16da2194964636c7d?s=96&d=mm&r=g","first_name":"Julie","user_url":"","last_name":"Bowie","description":"I am Julie Bowie a data scientist with a specialization in machine learning. I have conducted research in the field of language processing and has published several papers in reputable journals."},{"term_id":2631,"user_id":38,"is_guest":0,"slug":"kajal","display_name":"Kajal","avatar_url":"https:\/\/pickl.ai\/blog\/wp-content\/uploads\/2024\/07\/avatar_user_38_1722418842-96x96.jpg","first_name":"Kajal","user_url":"","last_name":"","description":"Kajal has joined our Organization as an Analyst in Gurgaon. She did her Graduation in B.sc(H) in Computer Science from Keshav Mahavidyalaya, Delhi University, and Masters in Computer Application from Indira Gandhi Delhi Technical University For Women, Kashmere Gate. Her expertise lies in Python, SQL, ML, and Data visualization. Her hobbies are Reading Self Help books, Writing gratitude journals, Watching cricket, and Reading articles."}],"_links":{"self":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/16176","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/comments?post=16176"}],"version-history":[{"count":1,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/16176\/revisions"}],"predecessor-version":[{"id":16178,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/posts\/16176\/revisions\/16178"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/media\/16177"}],"wp:attachment":[{"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/media?parent=16176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/categories?post=16176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/tags?post=16176"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.pickl.ai\/blog\/wp-json\/wp\/v2\/ppma_author?post=16176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}