{"id":23695,"date":"2023-11-03T02:38:28","date_gmt":"2023-11-03T02:38:28","guid":{"rendered":"https:\/\/chartexpo.com\/blog\/?p=23695"},"modified":"2025-12-05T01:25:18","modified_gmt":"2025-12-04T20:25:18","slug":"how-to-make-an-xy-graph-in-google-sheets","status":"publish","type":"post","link":"https:\/\/chartexpo.com\/blog\/how-to-make-an-xy-graph-in-google-sheets","title":{"rendered":"How to Make an XY Graph in Google Sheets?"},"content":{"rendered":"<p>In the modern world, data is precious, particularly for understanding performance, consumers, and markets.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/01\/how-to-make-an-xy-graph-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/01\/how-to-make-an-xy-graph-in-google-sheets.jpg\" alt=\"how to make an x y graph in google sheets\" width=\"650\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTE5Nys=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/08\/CTA-in-google-sheets-1.jpg\" alt=\"\" width=\"308\" height=\"143\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTE5Nys=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/08\/CTA-in-microsoft-excel-1.jpg\" alt=\"\" width=\"308\" height=\"143\" \/><\/a><\/div>\n<p>But let&#8217;s be honest: Calculating numbers is not fun or interesting. And because of this, it&#8217;s critical to investigate how to convey raw data compellingly and clearly.<\/p>\n<p>XY Graphs are helpful in this situation. You can use the XY Chart template in Google Sheets to view your data and gain insights. However, customization will take a lot of time and effort because it is only a basic tool. But worry not. This guide will inform you how to make an XY Graph in Google Sheets.<\/p>\n<h3>Table of Contents:<\/h3>\n<ol>\n<li><a href=\"#tb1\">What is an XY Graph in Google Sheets?<\/a><\/li>\n<li><a href=\"#tb2\">Understanding the Basics of Google Sheets X-Y Graph<\/a><\/li>\n<li><a href=\"#tb3\">Why do we use XY Graph in Google Sheets?<\/a><\/li>\n<li><a href=\"#tb4\">When to Use XY Graph in Google Sheets?<\/a><\/li>\n<li><a href=\"#tb5\">Google Sheets XY Graphs Examples<\/a><\/li>\n<li><a href=\"#tb6\">How to Make an XY Graph in Google Sheets?<\/a><\/li>\n<li><a href=\"#tb7\">How to Edit an X and Y Graph in Google Sheets?<\/a><\/li>\n<li><a href=\"#tb8\">What are the Pros of an XY Graph in Google Sheets?<\/a><\/li>\n<li><a href=\"#wrap-up\">Wrap Up<\/a><\/li>\n<\/ol>\n<h2 id=\"tb1\">What is an XY Graph in Google Sheets?<\/h2>\n<p>There are occasionally connections between important measures in your data. Comprehending these connections can help you find insights to put into practice.<\/p>\n<p>Many call center managers are keen on the correlation between the number of individuals working a shift and the typical answer time. You can utilize an XY Graph in Google Sheets to draw out relationship insights from your data. This simple chart reveals relationships that tables and other visualization techniques, like <a href=\"https:\/\/chartexpo.com\/charts\/bar-charts\" target=\"_blank\" rel=\"noopener noreferrer\">bar charts<\/a>, cannot show.<\/p>\n<p>This chart uses dots to denote significant data points. The placement of each dot on the horizontal and vertical axis shows values for data points. \u201d\u02dc&#8217;Use the chart below to see how two variables in your data relate to one another.&#8221;<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/01\/xy-graph-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/01\/xy-graph-in-google-sheets.jpg\" alt=\"x y graph in google sheets\" width=\"633\" \/><\/a><\/div>\n<h2 id=\"tb2\">Understanding the Basics of Google Sheets X-Y Graph<\/h2>\n<p>An x-y graph, or Cartesian coordinate system, is a <a href=\"https:\/\/chartexpo.com\/blog\/data-presentation\" target=\"_blank\" rel=\"noopener noreferrer\"><span data-sheets-root=\"1\" data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;data presentation&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:513,&quot;3&quot;:{&quot;1&quot;:0},&quot;12&quot;:0}\">presentation<\/span> of data<\/a> points plotted on two perpendicular axes: the x-axis (horizontal) and y-axis (vertical).<\/p>\n<p>It&#8217;s used to analyze relationships between variables, <a href=\"https:\/\/chartexpo.com\/blog\/trend-analysis-in-excel\" target=\"_blank\" rel=\"noopener noreferrer\">trend analysis<\/a>, and visualize mathematical functions or equations.<\/p>\n<h2 id=\"tb3\">Why do we use XY Graph in Google Sheets?<\/h2>\n<p>We use XY graphs in Google Sheets to visualize and analyze relationships between two variables. By plotting data points on the x and y axes, we can identify patterns, trends, correlations, and other insights that help us understand the relationship between the variables being studied.<\/p>\n<h2 id=\"tb4\">When to Use XY Graph in Google Sheets?<\/h2>\n<p>You may use various <a href=\"https:\/\/chartexpo.com\/blog\/types-of-charts-and-graphs\" target=\"_blank\" rel=\"noopener noreferrer\">graphs and charts<\/a> to visualize your data and get insights. However, a wider range of elements, such as your objective and context, play a role in selecting the best.<\/p>\n<p>See the examples below to learn the best uses for <a href=\"https:\/\/chartexpo.com\/tools\/google-sheets\" target=\"_blank\" rel=\"noopener noreferrer\">Google Sheets Graph<\/a> X and Y.<\/p>\n<ul>\n<li>\n<h3>Utilize an XY Graph in Google Sheets to Examine the Connections between Essential Data Variables.<\/h3>\n<\/li>\n<\/ul>\n<p>You can examine the potential relationship between your data&#8217;s crucial parameters by plotting this chart to see whether it exists. Observing and illuminating correlations between two numerical variables is the primary purpose of XY Graph.<\/p>\n<ul>\n<li>\n<h3>Visualizing Causal Effect in Company Data<\/h3>\n<\/li>\n<\/ul>\n<p>The ability to visualize causal-effect linkages in your business data using XY charts is also a helpful skill. For example, lack of cleanliness and customer service are the leading causes of restaurant customer complaints.<\/p>\n<p>The purpose of an XY Graph is to obtain causal-effect insights. It is simple to see how a factor, like customer returns, directly contributes to a problem that costs money.<\/p>\n<ul>\n<li>\n<h3>In circumstances where the Independent Variable has Numerous Values<\/h3>\n<\/li>\n<\/ul>\n<p>This graph can investigate hidden connections between dependent and independent variables in your data. Use Google Sheets Graph X and Y to see the link between data points that logically go together: sales revenue and profits.<\/p>\n<p>As we previously stated, how to make an XY Graph in Google Sheets need not be complicated. With advice gathered from <a href=\"https:\/\/chartexpo.com\/blog\/data-visualization-guide\" target=\"_blank\" rel=\"noopener noreferrer\">data visualization<\/a> specialists, we&#8217;ve got you covered. You shouldn&#8217;t miss this, so keep reading.<\/p>\n<h2 id=\"tb5\">Google Sheets XY Graphs Examples<\/h2>\n<ol>\n<li><strong>Financial Correlation<\/strong>: XY graphs can depict the correlation between two financial assets, aiding investors in understanding their relationship.<\/li>\n<li><strong>Scientific Experiments<\/strong>: They&#8217;re crucial in scientific research, displaying variables like temperature against reaction rates, and facilitating analysis.<\/li>\n<li><strong>Market Analysis<\/strong>: In marketing, XY graphs help assess advertising effectiveness by plotting expenditure against sales revenue, and guiding resource allocation.<\/li>\n<\/ol>\n<h2 id=\"tb6\">How to Make an XY Graph in Google Sheets?<\/h2>\n<p>You can&#8217;t easily reach some of the controls for modifying Google Sheets since they are too far away. As a result, using Google Sheets XY Graph Maker to create an <a href=\"https:\/\/chartexpo.com\/blog\/x-and-y-axis-chart\" target=\"_blank\" rel=\"noopener noreferrer\">X and Y Axis Chart<\/a> to visualize your data will take a lot of time. Make it perfect to fit your content needs.<\/p>\n<p>So what&#8217;s the answer?<\/p>\n<p>With a third-party add-on, you can make it the most reliable tool. There are many add-ons for Google Sheets for data visualization, but <a href=\"https:\/\/chartexpo.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">ChartExpo<\/a> is the best we suggest.<\/p>\n<p>ChartExpo achieves perfect marks across the board (in our checklist).<\/p>\n<ul>\n<li>Simplicity of use<\/li>\n<li>Cost of access<\/li>\n<li>The quality of charts produced<\/li>\n<li>Impact on your browser<\/li>\n<\/ul>\n<p>Even better, ChartExpo does not require coding or programming knowledge, unlike other data visualization-based extensions.<\/p>\n<p>How to install ChartExpo in Google Sheets?<\/p>\n<ol>\n<li>You can download ChartExpo directly from the Google Sheets App. To get started, click on Extensions in the top toolbar.<\/li>\n<li>In the menu that appears, go to Add-ons and press the option Get add-ons.<\/li>\n<li>Search for ChartExpo in the bar and click the Charts, Graphs &amp; Visualizations by ChartExpo when it appears in the results.<\/li>\n<li>Press the Install button, you will have to accept some permissions and you may have to confirm your Google account.<\/li>\n<\/ol>\n<p>There is another direct way to install ChartExpo by clicking on the below link as well for your desired tool.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTE5Nys=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/08\/CTA-in-google-sheets-2.jpg\" alt=\"\" width=\"308\" height=\"143\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTE5Nys=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/08\/CTA-in-microsoft-excel-2.jpg\" alt=\"\" width=\"308\" height=\"143\" \/><\/a><\/div>\n<p>Suppose you have two online stores and you want to analyze sales, profit margin, &amp; the number of orders. Here is the data below.<\/p>\n<table class=\"static\" style=\"table-layout: fixed; overflow-x: auto; border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td><strong>Stores<\/strong><\/td>\n<td><strong>Items<\/strong><\/td>\n<td><strong>Sales<\/strong><\/td>\n<td><strong>Profit %<\/strong><\/td>\n<td><strong>Number of Orders<\/strong><\/td>\n<\/tr>\n<tr>\n<td>Great Store<\/td>\n<td>Grocery<\/td>\n<td>3195<\/td>\n<td>12<\/td>\n<td>405<\/td>\n<\/tr>\n<tr>\n<td>Great Store<\/td>\n<td>Household &amp; Pet Care<\/td>\n<td>3588<\/td>\n<td>30<\/td>\n<td>382<\/td>\n<\/tr>\n<tr>\n<td>Great Store<\/td>\n<td>Health &amp; Beauty<\/td>\n<td>4491<\/td>\n<td>32<\/td>\n<td>343<\/td>\n<\/tr>\n<tr>\n<td>Great Store<\/td>\n<td>DIY &amp; Furniture<\/td>\n<td>3169<\/td>\n<td>26<\/td>\n<td>541<\/td>\n<\/tr>\n<tr>\n<td>Great Store<\/td>\n<td>Office Supplies<\/td>\n<td>4970<\/td>\n<td>13<\/td>\n<td>567<\/td>\n<\/tr>\n<tr>\n<td>Great Store<\/td>\n<td>Sports &amp; Leisure<\/td>\n<td>3794<\/td>\n<td>10<\/td>\n<td>378<\/td>\n<\/tr>\n<tr>\n<td>Great Store<\/td>\n<td>Electronics<\/td>\n<td>5953<\/td>\n<td>26<\/td>\n<td>326<\/td>\n<\/tr>\n<tr>\n<td>Great Store<\/td>\n<td>Entertainment<\/td>\n<td>5634<\/td>\n<td>31<\/td>\n<td>342<\/td>\n<\/tr>\n<tr>\n<td>One-Click Picks<\/td>\n<td>Garments<\/td>\n<td>5520<\/td>\n<td>34<\/td>\n<td>521<\/td>\n<\/tr>\n<tr>\n<td>One-Click Picks<\/td>\n<td>Cosmetics<\/td>\n<td>3042<\/td>\n<td>14<\/td>\n<td>451<\/td>\n<\/tr>\n<tr>\n<td>One-Click Picks<\/td>\n<td>Toys<\/td>\n<td>3940<\/td>\n<td>27<\/td>\n<td>503<\/td>\n<\/tr>\n<tr>\n<td>One-Click Picks<\/td>\n<td>Books<\/td>\n<td>3630<\/td>\n<td>25<\/td>\n<td>533<\/td>\n<\/tr>\n<tr>\n<td>One-Click Picks<\/td>\n<td>Garden &amp; Outdoor<\/td>\n<td>4535<\/td>\n<td>24<\/td>\n<td>380<\/td>\n<\/tr>\n<tr>\n<td>One-Click Picks<\/td>\n<td>Cleaning supplies<\/td>\n<td>3618<\/td>\n<td>21<\/td>\n<td>335<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul>\n<li>To get started with ChartExpo, install ChartExpo in Google Sheets from\u00a0<a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTE5Nys=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">this link<\/a>.<\/li>\n<li>Go to <strong>Extensions<\/strong> &gt; <strong>Charts, Graphs &amp; Visualizations by ChartExpo<\/strong> &gt; <strong>Open<\/strong>.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/open-chartexpo-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/open-chartexpo-in-google-sheets.jpg\" alt=\"open chartexpo in google sheets\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>To access your chart library, click the <strong>Add new chart<\/strong> button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/add-new-chart-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/add-new-chart-in-google-sheets.jpg\" alt=\"add new chart in google sheets\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Once <strong>ChartExpo<\/strong> is loaded, you will see a list of charts.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/list-of-charts-graphs-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/list-of-charts-graphs-google-sheets.jpg\" alt=\"list of charts graphs google sheets\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Then, scroll through the numerous chart templates until you see the <strong>Scatter Plot<\/strong>.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/10\/search-scatter-plot-chart-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/10\/search-scatter-plot-chart-in-google-sheets.jpg\" alt=\"search XY chart in google sheets\" width=\"663\" \/><\/a><\/div>\n<ul>\n<li>Choose the Metrics option after selecting the sheet that contains your data. Add the corresponding numbers (in our example, we&#8217;ll add the Sales, Profit %, and Number of orders).<\/li>\n<li>To add dimensional data, click the Dimensions button and enter the desired values (in our case, we&#8217;ll use Items and Stores).<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/01\/create-scatter-plot-chart-in-google-sheets-197.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/01\/create-scatter-plot-chart-in-google-sheets-197.jpg\" alt=\"create xy chart in google sheets\" width=\"636\" \/><\/a><\/div>\n<ul>\n<li>You can use these simple steps for how to make an XY graph in Google Sheets. The process is smooth and straightforward, thanks to ChartExpo.<\/li>\n<li>Click the <strong>Create Chart<\/strong> button to complete the quick procedure and generate an XY Chart for your data.<\/li>\n<li>Your example of an XY Graph should resemble this if you follow the preceding procedures (below).<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/01\/edit-scatter-plot-chart-in-google-sheets-197.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/01\/edit-scatter-plot-chart-in-google-sheets-197.jpg\" alt=\"edit xy chart in google sheets\" width=\"644\" \/><\/a><\/div>\n<h2 id=\"tb7\">How to Edit an X and Y Graph in Google Sheets?<\/h2>\n<p>Here are simple edits to accomplish on the XY Graph maker.<\/p>\n<h3>How to add Postfixes and prefixes?<\/h3>\n<p>Follow these easy procedures to add prefixes and postfixes, such as currency symbols:<\/p>\n<ul>\n<li>To edit the x-axis, select the pencil-shaped icon.<\/li>\n<li>Click the Label Text in the Axis Bottom Properties interface after it appears. Add the dollar sign.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/01\/settings-scatter-plot-chart-in-google-sheets-197.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/01\/settings-scatter-plot-chart-in-google-sheets-197.jpg\" alt=\"settings xy chart in google sheets\" width=\"644\" \/><\/a><\/div>\n<ul>\n<li>Choose &#8220;<strong>Apply All<\/strong>&#8221; from the menu.<\/li>\n<li>Click the pencil-shaped icon next to the y-axis to add a postfix.<\/li>\n<li>When the Axis Left Properties interface appears, select Label Text by clicking the button.<\/li>\n<li>When prompted, type your % in the Postfix.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/01\/apply-settings-scatter-plot-chart-in-google-sheets-197.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/01\/apply-settings-scatter-plot-chart-in-google-sheets-197.jpg\" alt=\"apply settings x and y graph in google sheets\" width=\"647\" \/><\/a><\/div>\n<h3>How to add a legend?<\/h3>\n<ul>\n<li>If you wish to add a legend to the XY Graph, click the pencil-shaped icon.<\/li>\n<li>When the Legend Properties box appears, enable the Show button.<\/li>\n<li>Click the Apply function to save the changes.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/01\/apply-functions-scatter-plot-chart-in-google-sheets-197.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/01\/apply-functions-scatter-plot-chart-in-google-sheets-197.jpg\" alt=\"apply functios XY graph in google sheets\" width=\"644\" \/><\/a><\/div>\n<h3>How to add a title<\/h3>\n<ul>\n<li>Select the pencil-shaped icon next to the title placeholder.<\/li>\n<li>Once the Property window appears, type &#8220;Online Store Sales Analysis&#8221; in the Line 1 text box.<\/li>\n<li>Next, select Show from the menu and move the switch to the right (i.e., on position).<\/li>\n<li>Click the Apply button to keep the changes.<\/li>\n<li>Click the Save button to keep your adjustments in the XY Graph.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/01\/save-scatter-plot-chart-in-google-sheets-197.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/01\/save-scatter-plot-chart-in-google-sheets-197.jpg\" alt=\"save XY graph in google sheets\" width=\"645\" \/><\/a><\/div>\n<ul>\n<li>Here is your final chart.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/01\/how-to-create-an-xy-graph-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/01\/how-to-create-an-xy-graph-in-google-sheets.jpg\" alt=\"how to create an x y graph in google sheets\" width=\"646\" \/><\/a><\/div>\n<h4>\u00a0Insights<\/h4>\n<ul>\n<li>Here the Dot size represents the number of orders.<\/li>\n<li>Garments and electronics have high sales, &amp; profit margins. But Garments have high numbers of order. On the other hand, Electronics have low numbers of orders.<\/li>\n<li>Cosmetics and groceries have low sales and profit margins. But both items have the almost same number of orders.<\/li>\n<li>DIY &amp; Furniture have low sales. But it has a high-profit margin and several orders.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTE5Nys=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/10\/scatter-plot-chart-generator-in-google-sheets-3.jpg\" alt=\"\" width=\"319\" height=\"149\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTE5Nys=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/10\/scatter-plot-chart-generator-in-excel-3.jpg\" alt=\"\" width=\"319\" height=\"149\" \/><\/a><\/div>\n<h3>Revolutionize Data Connections by Combining XY Graphs in Google Sheets:<\/h3>\n<div>\n<ol>\n<li>Open your Excel Application.<\/li>\n<li>Install\u00a0<a href=\"https:\/\/www.youtube.com\/watch?v=yW3EjBDO-sM\" target=\"_blank\" rel=\"noopener nofollow noreferrer\">ChartExpo Add-in for Excel<\/a> from\u00a0Microsoft AppSource to create <a href=\"https:\/\/chartexpo.com\/blog\/interactive-storytelling\" target=\"_blank\" rel=\"noopener\">interactive visualizations<\/a>.<\/li>\n<li>Select the <a href=\"https:\/\/chartexpo.com\/charts\/scatter-plot-chart\" target=\"_blank\" rel=\"noopener\">Scatter Plot<\/a> from the list of charts.<\/li>\n<li>Select your data<\/li>\n<li>Click on the \u201cCreate Chart from Selection\u201d button.<\/li>\n<li>Customize your chart properties to add header, axis, legends, and other required information.<\/li>\n<li>Export your chart and share it with your audience.<\/li>\n<\/ol>\n<p>The following video will help you to create a Scatter Plot in Microsoft Excel.<\/p>\n<\/div>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/0xGz6jTj9XI?si=ylTU3ezGUtLL38Or\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTE5Nys=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/10\/scatter-plot-chart-generator-in-google-sheets-3.jpg\" alt=\"\" width=\"319\" height=\"149\" \/><\/a> <a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTE5Nys=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/10\/scatter-plot-chart-generator-in-excel-3.jpg\" alt=\"\" width=\"319\" height=\"149\" \/><\/a><\/div>\n<h2 id=\"tb8\">What are the Pros of an XY Graph in Google Sheets?<\/h2>\n<ul>\n<li><strong>Clear Data Visualization:<\/strong> Easily identify patterns and correlations between two variables.<\/li>\n<li><strong>Customizable:<\/strong> Various options for colors, shapes, trendlines, and labels.<\/li>\n<li><strong>Real-Time Collaboration:<\/strong> Multiple users can work on the same graph simultaneously.<\/li>\n<li><strong>Accessibility:<\/strong> Access your graphs from any device with internet connectivity.<\/li>\n<li><strong>Seamless Integration:<\/strong> Works well with other Google Workspace tools.<\/li>\n<\/ul>\n<h2>Frequently Asked Questions About the XY Chart in Google Sheets<\/h2>\n<h3 class=\"JlqpRe\"><span class=\"JCzEY tNxQIb\"><span class=\"CSkcDe\">Can you graph an equation on Google Sheets?<\/span><\/span><\/h3>\n<div class=\"p8Jhnd\">\n<div class=\"aj35ze\">Yes, you can graph an equation on Google Sheets by creating a table of values that satisfy the equation. Enter your X values in one column and use a formula to calculate the corresponding Y values in the next column. Then, select the data and use the chart tool to create an XY scatter plot.<\/div>\n<\/div>\n<h3>How do you label XY on a graph?<\/h3>\n<div>\n<div class=\"p8Jhnd\">\n<div class=\"aj35ze\">\n<p>To label the X and Y axes on a graph in Google Sheets:<\/p>\n<ol>\n<li>Select the chart.<\/li>\n<li>Click on the three vertical dots in the upper right corner and select &#8220;Edit chart.&#8221;<\/li>\n<li>Go to the &#8220;Customize&#8221; tab.<\/li>\n<li>Expand the &#8220;Chart &amp; axis titles&#8221; section.<\/li>\n<li>Enter the labels for the X and Y axes in the provided fields.<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<\/div>\n<h4 id=\"wrap-up\">Wrap Up<\/h4>\n<p>How to make an XY Graph in Google Sheets doesn&#8217;t have to be complicated. We have just discussed the process in detail above. We advise you to take your time and read the informative advice about how to make an XY in Google Sheets quickly and easily.<\/p>\n<p>Which program is the most effective for use with an XY Graph to visualize data? One of the most prevalent tools for visualizing data is Google Sheets. Furthermore, it includes an XY graph and an easy-to-use Plot.<\/p>\n<p>Because ChartExpo is one of the most reliable add-ons, we suggest using it to create XY Graph. Additionally, there are plenty of users worldwide. It is also incredibly user-friendly for anyone, regardless of their level of computer proficiency.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>Learn how to make an XY graph in Google Sheets with our step-by-step guide. Input data, select chart type, customize, and insert for insightful visualizations.<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/chartexpo.com\/blog\/how-to-make-an-xy-graph-in-google-sheets\"><\/a><\/p>","protected":false},"author":1,"featured_media":23708,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[743],"tags":[1031,1030,1032],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>How to Make an XY Graph in Google Sheets? -<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/chartexpo.com\/blog\/how-to-make-an-xy-graph-in-google-sheets\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:title\" content=\"How to Make an XY Graph in Google Sheets? -\" \/>\r\n<meta name=\"twitter:description\" content=\"Learn how to make an XY graph in Google Sheets with our step-by-step guide. Input data, select chart type, customize, and insert for insightful visualizations.\" \/>\r\n<meta name=\"twitter:image\" content=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/01\/feature-ce197.jpg\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"13 minutes\" \/>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Make an XY Graph in Google Sheets? -","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:\/\/chartexpo.com\/blog\/how-to-make-an-xy-graph-in-google-sheets","twitter_card":"summary_large_image","twitter_title":"How to Make an XY Graph in Google Sheets? -","twitter_description":"Learn how to make an XY graph in Google Sheets with our step-by-step guide. Input data, select chart type, customize, and insert for insightful visualizations.","twitter_image":"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/01\/feature-ce197.jpg","twitter_misc":{"Written by":"admin","Est. reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/chartexpo.com\/blog\/how-to-make-an-xy-graph-in-google-sheets","url":"https:\/\/chartexpo.com\/blog\/how-to-make-an-xy-graph-in-google-sheets","name":"How to Make an XY Graph in Google Sheets? -","isPartOf":{"@id":"http:\/\/localhost\/blog\/#website"},"datePublished":"2023-11-03T02:38:28+00:00","dateModified":"2025-12-04T20:25:18+00:00","author":{"@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280"},"breadcrumb":{"@id":"https:\/\/chartexpo.com\/blog\/how-to-make-an-xy-graph-in-google-sheets#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/chartexpo.com\/blog\/how-to-make-an-xy-graph-in-google-sheets"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/chartexpo.com\/blog\/how-to-make-an-xy-graph-in-google-sheets#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/localhost\/blog"},{"@type":"ListItem","position":2,"name":"How to Make an XY Graph in Google Sheets?"}]},{"@type":"WebSite","@id":"http:\/\/localhost\/blog\/#website","url":"http:\/\/localhost\/blog\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/localhost\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280","name":"admin","url":"https:\/\/chartexpo.com\/blog\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/23695"}],"collection":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/comments?post=23695"}],"version-history":[{"count":25,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/23695\/revisions"}],"predecessor-version":[{"id":45009,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/23695\/revisions\/45009"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media\/23708"}],"wp:attachment":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=23695"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=23695"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=23695"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}