{"id":262116,"date":"2024-03-13T20:07:27","date_gmt":"2024-03-13T19:07:27","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=262116"},"modified":"2026-09-28T14:20:34","modified_gmt":"2026-09-28T12:20:34","slug":"eixos-x-e-y","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/google-sheets-features\/x-and-y-axis\/","title":{"rendered":"Eixos X e Y: defini\u00e7\u00e3o, equa\u00e7\u00e3o e exemplos"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221; da_disable_devices=&#8221;off|off|off&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>If you need to plot a 2D graph using coordinates or an equation describing them, you\u2019ll need to know about the X and Y axes, what they represent, and the order in which to use them. In this guide, you will learn about the X and Y axes and how to use them to plot coordinates on a 2D graph. You will also learn how to use the scatter chart in Google Sheets.<\/p>\n<p>First, you will learn how to plot coordinates in the form of ordered pairs. After that, you will learn how to find coordinates using different types of equations. Finally, you will learn how to switch the X and Y axes in your Google Sheets graphs.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;what-is-the-x-and-y-axis&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>What is the X and Y axis?<\/h2>\n<p>The coordinate grids on a 2D graph have two perpendicular lines called axes. These axes are labeled like number lines, and the point where they intersect is called the origin. The horizontal axis is usually called the X-axis, and the vertical one is called the Y-axis.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;which-is-first-x-or-y&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Which is first: X or Y?<\/h2>\n<p>All points on the plane of these axes are defined by their coordinates, given by an ordered pair (X,Y). For example, the coordinates of the origin are (0,0). The order is important when communicating these coordinates, and x always goes first. In the next section, you have several examples to illustrate this.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;examples-of-using-the-x-and-y-axis&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Examples of using the X and Y axis<\/h2>\n<p>Now that you know what the X and Y axes are, let\u2019s see how you can use them to plot coordinates on a graph, whether they are in the form of ordered pairs or an equation describing the relationship between X and Y.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;plot-coordinates-on-a-graph&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Plot coordinates on a graph<\/h2>\n<p>First, let\u2019s see how to plot coordinates on a graph manually.<\/p>\n<p><strong>1.<\/strong> You\u2019ve been given a set of ordered pairs that need to be plotted on a graph.<\/p>\n<p>Coordinates: (1,2), (2,3), (3,4), (4,3)<\/p>\n<p><strong>2.<\/strong> Your graph should have perpendicular lines that cross at (0,0). Each line should be divided into equal units, like a number line.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/x-and-y-axis-coordinate-grid.webp&#8221; alt=&#8221;X and Y axis \u2014 empty coordinate grid with the X and Y axes crossing at the origin&#8221; title_text=&#8221;Empty coordinate grid with the X and Y axes crossing at the origin&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3.<\/strong> On the X-axis, find the first number in the first ordered pair.<\/p>\n<p><strong>4.<\/strong> Move up perpendicular to the X-axis until you reach the second number of the ordered pair.<\/p>\n<p><strong>5<\/strong>. Mark the spot.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/x-and-y-axis-plot-first-coordinate.webp&#8221; alt=&#8221;X and Y axis \u2014 first ordered pair marked on the coordinate grid&#8221; title_text=&#8221;First ordered pair marked on the coordinate grid&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>6.<\/strong> Repeat steps 3-5 for each ordered pair, as shown below.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/x-and-y-axis-all-coordinates-plotted.webp&#8221; alt=&#8221;X and Y axis \u2014 four ordered pairs plotted on the coordinate grid&#8221; title_text=&#8221;Four ordered pairs plotted on the coordinate grid&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;plot-coordinates-on-a-graph-using-google&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Plot coordinates on a graph using Google Sheets<\/h2>\n<p>Now, let\u2019s see how to plot the coordinates from the previous example using Google Sheets. First, you need to organize the coordinates in tabular form, then use a <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-make-a-scatter-plot-in-google-sheets\/\">scatter chart<\/a> to graph them.<\/p>\n<p><strong>1.<\/strong> Open Google Sheets.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/x-and-y-axis-google-sheets-blank-sheet.webp&#8221; alt=&#8221;X and Y axis in Google Sheets \u2014 blank Google Sheets spreadsheet ready for the coordinate table&#8221; title_text=&#8221;Blank Google Sheets spreadsheet ready for the coordinate table&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> Create a two-column table with the ordered pairs, as shown below.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/x-and-y-axis-google-sheets-coordinate-table.webp&#8221; alt=&#8221;X and Y axis in Google Sheets \u2014 two-column Google Sheets table holding the X and Y values&#8221; title_text=&#8221;Two-column Google Sheets table holding the X and Y values&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3.<\/strong> Select the cells containing the X and Y coordinates, and go to Insert &gt; Chart. If you have not built one before, the guide to <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/insert-a-chart-in-google-sheets\/\">inserting a chart in Google Sheets<\/a> covers every chart type.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/x-and-y-axis-google-sheets-select-values.webp&#8221; alt=&#8221;X and Y axis in Google Sheets \u2014 X and Y columns selected with the Insert menu open&#8221; title_text=&#8221;X and Y columns selected with the Insert menu open&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4.<\/strong> From the \u2018Chart editor\u2019, under \u2018Chart type\u2019, select the \u2018Scatter chart\u2019. Below, you can see that the coordinates have been plotted on the graph.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/09\/x-and-y-axis-google-sheets-ordered-pairs-scatter.webp&#8221; alt=&#8221;X and Y axis in Google Sheets \u2014 scatter chart plotting the four ordered pairs from the table&#8221; title_text=&#8221;Scatter chart plotting the four ordered pairs&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;plot-equations-on-a-graph-using-google-s&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Plot equations on a graph using Google Sheets<\/h2>\n<p>Now that you know how easy it is to plot coordinates using Google Sheets, it&#8217;s time to learn how to plot an equation describing the relationship between X and Y values. First, you need to create the Y values using the equation. Once you have these, you can graph them using a scatter chart.<\/p>\n<h3>Plot linear equations in Google Sheets<\/h3>\n<p>In this example, you will learn how to plot a linear equation using Google Sheets. The equation is the following:<\/p>\n<blockquote>\n<p>y = 3x + 3<\/p>\n<\/blockquote>\n<p><strong>1.<\/strong> Open Google Sheets and add column headers for X and Y, as shown below.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/x-and-y-axis-google-sheets-table-headers.webp&#8221; alt=&#8221;X and Y axis in Google Sheets \u2014 X and Y column headers added in Google Sheets&#8221; title_text=&#8221;X and Y column headers added in Google Sheets&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> For the X values, type the numbers from 1 to 10, one per row.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/x-and-y-axis-google-sheets-x-values.webp&#8221; alt=&#8221;X and Y axis in Google Sheets \u2014 X column filled with the numbers 1 to 10 in Google Sheets&#8221; title_text=&#8221;X column filled with the numbers 1 to 10 in Google Sheets&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3.<\/strong> In the cell where you want the first Y value, type in the equation, replacing the X with the cell reference for the first value of X, as shown below.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/x-and-y-axis-google-sheets-linear-formula.webp&#8221; alt=&#8221;X and Y axis in Google Sheets \u2014 linear equation typed into the first Y cell in Google Sheets&#8221; title_text=&#8221;Linear equation typed into the first Y cell in Google Sheets&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4.<\/strong> Grab the fill handle and drag it down to the last value.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/x-and-y-axis-google-sheets-fill-handle.webp&#8221; alt=&#8221;X and Y axis in Google Sheets \u2014 fill handle dragged down the Y column in Google Sheets&#8221; title_text=&#8221;Fill handle dragged down the Y column in Google Sheets&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>5.<\/strong> Select the values for X and Y and go to Insert &gt; Chart.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/x-and-y-axis-google-sheets-insert-chart.webp&#8221; alt=&#8221;X and Y axis in Google Sheets \u2014 Insert menu open over the selected X and Y values in Google Sheets&#8221; title_text=&#8221;Insert menu open over the selected X and Y values in Google Sheets&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>6.<\/strong> Make sure the chart type is a \u2018Scatter chart\u2019.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/x-and-y-axis-google-sheets-scatter-chart.webp&#8221; alt=&#8221;X and Y axis in Google Sheets \u2014 scatter chart of y = 3x + 3 for X values 1 to 10&#8243; title_text=&#8221;Scatter chart of the linear equation y = 3x + 3&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>7.<\/strong> You can <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/create-a-trendline-in-google-sheets\/\">add a trendline<\/a> and use the equation as the label. Go to \u2018Customize\u2019 in the \u2018Chart editor\u2019 and click on \u2018Series\u2019. Scroll down, check the \u2018Trendline\u2019 checkbox, and select \u2018Equation\u2019 under \u2018Label\u2019.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/x-and-y-axis-google-sheets-trendline-equation.webp&#8221; alt=&#8221;X and Y axis in Google Sheets \u2014 Chart editor with trendline enabled and the equation set as the label&#8221; title_text=&#8221;Chart editor with trendline enabled and the equation set as the label&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Plot quadratic equations in Google Sheets<\/h3>\n<p>In this example, you will learn how to plot a quadratic equation on a Google Sheets scatter chart. The equation is as follows:<\/p>\n<blockquote>\n<p>y = 4x^2<\/p>\n<\/blockquote>\n<p><strong>1.<\/strong> In Google Sheets, add column headers for X and Y. In the first column, type the numbers from 1 to 10, one per row.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/x-and-y-axis-google-sheets-quadratic-x-values.webp&#8221; alt=&#8221;X and Y axis in Google Sheets \u2014 X column filled with 1 to 10 for the quadratic example in Google Sheets&#8221; title_text=&#8221;X column filled with 1 to 10 for the quadratic example in Google Sheets&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> In the cell where you want the first Y value, type in the equation, replacing the X with the cell reference for the first value of X, as shown below.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/x-and-y-axis-google-sheets-quadratic-formula.webp&#8221; alt=&#8221;X and Y axis in Google Sheets \u2014 quadratic equation typed into the first Y cell in Google Sheets&#8221; title_text=&#8221;Quadratic equation typed into the first Y cell in Google Sheets&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3.<\/strong> Grab the fill handle and drag it down to get the rest of the Y values.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/x-and-y-axis-google-sheets-quadratic-fill-down.webp&#8221; alt=&#8221;X and Y axis in Google Sheets \u2014 quadratic formula filled down the Y column in Google Sheets&#8221; title_text=&#8221;Quadratic formula filled down the Y column in Google Sheets&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4.<\/strong> Select the cells with the X and Y values and go to Insert &gt; Chart.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/x-and-y-axis-google-sheets-quadratic-insert-chart.webp&#8221; alt=&#8221;X and Y axis in Google Sheets \u2014 Insert menu open over the quadratic X and Y values in Google Sheets&#8221; title_text=&#8221;Insert menu open over the quadratic X and Y values in Google Sheets&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>5.<\/strong> Check that the chart type is the \u2018Scatter chart\u2019.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/x-and-y-axis-google-sheets-quadratic-scatter-chart.webp&#8221; alt=&#8221;X and Y axis in Google Sheets \u2014 scatter chart of the quadratic equation in Google Sheets&#8221; title_text=&#8221;Scatter chart of the quadratic equation in Google Sheets&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;how-to-switch-the-x-and-y-axis&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to switch the X and Y axis?<\/h2>\n<p>When creating graphs or charts, Google Sheets takes a pretty good guess at the type of chart you want, and which values are on the X and Y axes. However, you may need to switch them to visualize data more clearly. As the expectation is that X values will be on the horizontal axis, be sure to change the labels to avoid confusion.<\/p>\n<p>You already know how to change the chart type, but how do you switch the axes? Follow the instructions below to flip the axes on your Google Sheets graph.<\/p>\n<p><strong>1.<\/strong> Select your chart and double click to get the \u2018Chart editor\u2019.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/x-and-y-axis-google-sheets-chart-editor.webp&#8221; alt=&#8221;X and Y axis in Google Sheets \u2014 Google Sheets Chart editor panel open on the Setup tab&#8221; title_text=&#8221;Google Sheets Chart editor panel open on the Setup tab&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> In the \u2018Setup\u2019 tab, you can see the selection for the \u2018X-axis\u2019 and the \u2018Y-axis\u2019, labeled as \u2018Series\u2019. Use the dropdown menus to switch them.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/x-and-y-axis-google-sheets-switch-axes.webp&#8221; alt=&#8221;X and Y axis in Google Sheets \u2014 Chart editor dropdowns used to swap the X-axis and Series values&#8221; title_text=&#8221;Chart editor dropdowns used to swap the X-axis and Series values&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3.<\/strong> That\u2019s it. However, the Y-axis label needs to be changed, too.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/x-and-y-axis-google-sheets-wrong-axis-label.webp&#8221; alt=&#8221;X and Y axis in Google Sheets \u2014 chart showing the old Y-axis label after the axes were switched&#8221; title_text=&#8221;Chart showing the old Y-axis label after the axes were switched&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4.<\/strong> Right-click to get the menu or go to \u2018Chart &amp; axis titles\u2019 in the \u2018Customize\u2019 tab.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/x-and-y-axis-google-sheets-change-axis-label.webp&#8221; alt=&#8221;X and Y axis in Google Sheets \u2014 Chart and axis titles option open in the Customize tab&#8221; title_text=&#8221;Chart and axis titles option open in the Customize tab&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>5.<\/strong> That\u2019s it. The X and Y axes have been switched.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/03\/x-and-y-axis-google-sheets-switched-axes.webp&#8221; alt=&#8221;X and Y axis in Google Sheets \u2014 finished Google Sheets chart with the X and Y axes switched&#8221; title_text=&#8221;Finished Google Sheets chart with the X and Y axes switched&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;conclusion&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Conclusion<\/h2>\n<p>It\u2019s easy to work with coordinate grids. You can easily plot coordinates on a 2D graph using ordered pairs. However, it&#8217;s even easier to do it in Google Sheets. You have step-by-step instructions on how to organize X and Y values in tabular form and how to graph them using a scatter chart in Google Sheets.<\/p>\n<p>You also know how to find coordinates using different types of equations and use the scatter chart to graph them. The same axis settings apply to other chart types, so it is worth reading how to <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-make-a-line-graph-in-google-sheets\/\">make a line graph<\/a> and how to <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-create-a-bar-chart-in-google-sheets\/\">create a bar chart in Google Sheets<\/a>. Finally, you know how to switch the X and Y axes and when it&#8217;s appropriate to do so.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn what the X and Y axis are, which one comes first, and how to plot coordinates and equations on a scatter chart in Google Sheets.<\/p>","protected":false},"author":2,"featured_media":262141,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[],"class_list":["post-262116","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/262116","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=262116"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/262116\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/262141"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=262116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=262116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=262116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}