{"id":264599,"date":"2024-03-13T20:08:32","date_gmt":"2024-03-13T19:08:32","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=264599"},"modified":"2026-10-14T15:36:51","modified_gmt":"2026-10-14T13:36:51","slug":"inclinacao-no-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/google-sheets-features\/how-to-find-slope-in-google-sheets\/","title":{"rendered":"Como calcular a inclina\u00e7\u00e3o no Google Sheets"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

If you need to present research reports, financial information, or solve mathematical problems, the concept of a slope and trendline may be familiar to you. Spreadsheet tools such as Excel or Google Sheets offer different ways to find, assess, and compare slopes in your table data.<\/p>\n

Although Google Sheets is more commonly used to store and structure information, it also allows for powerful tools and formulas to calculate and analyze financial data. If you\u2019re interested in exploring this side of Google Sheets, you\u2019ll soon be able to unlock the full potential of Google Sheets\u2019 advanced analytics and reporting features.<\/p>\n

In this article, you\u2019ll learn all about slopes, from the meaning behind this concept, to how to find the slope of a graph and trendline in Google Sheets. You\u2019ll learn how to find it using two methods: by creating a scatter chart and then obtaining the trendline equation, and without a chart, by using the SLOPE function.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”what-is-a-slope” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

What is a slope?<\/h2>\n

The slope is a geometric concept that refers to the direction and steepness of a line. This line usually appears on a standard x-y grid, i.e., a chart that has a vertical and horizontal axis. If the slope of the line rises from the left, it is said to be a positive slope; when it goes down, it\u2019s a negative slope.<\/p>\n

However, finding a slope in your data can be trickier than it seems. You\u2019ll first need to draw a trendline, which is basically the line that you\u2019ll need to find the slope. For example, what you see below is an example of a linear trendline, which shows an increase at a steady rate.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/slope-google-sheets-example-trendline.webp” alt=”Slope in Google Sheets \u2014 Investment vs. Start Date scatter chart with a rising linear trendline” title_text=”Investment vs. Start Date scatter chart with a rising linear trendline” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Now, let\u2019s see how you can find a slope in your data in Google Sheets.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”how-to-find-slope-in-google-sheets” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to find slope in Google Sheets?<\/h2>\n

You\u2019ll now learn how to find the slope in Google Sheets with and without a chart. First, let\u2019s see how to find the slope of a graph.<\/p>\n

If you only need to show a trend inside a single cell, the SPARKLINE function can create one-cell miniature charts \u2013 perfect for financial reports. Here\u2019s how to use SPARKLINE in Google Sheets<\/a>.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”how-to-find-the-slope-of-a-graph-in-goog” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to find the slope of a graph in Google Sheets?<\/h2>\n

You can easily find the slope by creating a scatter chart<\/a> from your table data and then adding a trendline<\/a>.<\/p>\n

How to create a scatter chart in Google Sheets?<\/h3>\n

Google Sheets offers a set of tools to create different chart types based on your data. This is how you can create a scatter chart in Google Sheets.<\/p>\n

1.<\/strong> Open your Google Sheets and select the table data you want to include in the chart.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/slope-google-sheets-select-table-data.webp” alt=”Slope of a graph in Google Sheets \u2014 Start Date and Investment columns selected in the Investment Trends sheet” title_text=”Start Date and Investment columns selected in the Investment Trends sheet” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

2.<\/strong> Click on the \u201cChart\u201d icon, to the far right, as shown below.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/slope-google-sheets-chart-icon.webp” alt=”Slope of a graph in Google Sheets \u2014 Investment Trends sheet with the data selected and the chart icon in the toolbar” title_text=”Investment Trends sheet with the data selected and the chart icon in the toolbar” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

3.<\/strong> You should see the \u201cChart editor\u201d pane to the far right. Under \u201cSetup\u201d, select \u201cScatter Chart\u201d under the \u201cChart Type\u201d drop-down menu.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/slope-google-sheets-scatter-chart-type.webp” alt=”Slope of a graph in Google Sheets \u2014 Chart editor Setup tab with Scatter chart as the chart type” title_text=”Chart editor Setup tab with Scatter chart as the chart type” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

4.<\/strong> Now, click the tab \u201cCustomize\u201d.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/slope-google-sheets-chart-editor-customize.webp” alt=”Slope of a graph in Google Sheets \u2014 Chart editor Customize tab listing Chart style, Series and axis sections” title_text=”Chart editor Customize tab listing Chart style, Series and axis sections” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

5.<\/strong> Click on the \u201cSeries\u201d group and then scroll down until you find the \u201cTrendline\u201d box.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/slope-google-sheets-series-trendline-box.webp” alt=”Slope of a graph in Google Sheets \u2014 Series settings with the Trendline checkbox at the bottom” title_text=”Series settings with the Trendline checkbox at the bottom” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

6.<\/strong> Check the \u201cTrendline\u201d box to add a trendline to your scatter chart.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/slope-google-sheets-trendline-scatter-chart.png” alt=”Slope of a graph in Google Sheets \u2014 Trendline box ticked and a trendline drawn across the scatter chart” title_text=”Trendline box ticked and a trendline drawn across the scatter chart” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

7.<\/strong> Scroll further down until you find the \u201cLabel\u201d menu. Click on the \u201cNone\u201d drop-down menu.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/slope-google-sheets-trendline-label-menu.png” alt=”Slope of a graph in Google Sheets \u2014 trendline options with the Label drop-down set to None” title_text=”Trendline options with the Label drop-down set to None” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

8.<\/strong> Select \u201cUse Equation\u201d from the options to add the corresponding equation to the trendline, which appears above the chart as an equation.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/slope-google-sheets-use-equation-label.webp” alt=”Slope of a graph in Google Sheets \u2014 Label set to Use Equation and 47.7*x + -2.06E+06 shown in the chart legend” title_text=”Label set to Use Equation and 47.7*x + -2.06E+06 shown in the chart legend” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

The format of the trendline equation in Google Sheets corresponds to the structure \u201cy=mx+b\u201d. The \u201cm\u201d and \u201cb\u201d are the numeric values, whereas \u201cx\u201d and \u201cy\u201d are variables. The slope of the trendline is the \u201cm\u201d number which appears to the left of the \u201cx\u201d.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”how-to-find-the-slope-without-using-char” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to find the slope without using charts in Google Sheets?<\/h2>\n

Now that you\u2019ve seen how to find the slope in Google Sheets using a chart, let\u2019s see how the SLOPE function can help you achieve the same thing without having to create a graph.<\/p>\n

SLOPE function syntax<\/h3>\n

The syntax is =SLOPE(data_y, data_x), where:<\/p>\n