{"id":44606,"date":"2023-09-28T00:32:19","date_gmt":"2023-09-27T22:32:19","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=44606"},"modified":"2026-10-14T16:22:19","modified_gmt":"2026-10-14T14:22:19","slug":"como-fazer-um-grafico-de-linhas-no-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/google-sheets-features\/how-to-make-a-line-graph-in-google-sheets\/","title":{"rendered":"Como criar um gr\u00e1fico de linhas no Planilhas Google"},"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

A line graph, also called a line chart, shows how one or more values change over time. Each data point is a marker, and a line joins the markers so you can see the trend at a glance. In Google Sheets, you can build one from a table with dates or periods in one column and values in the next.<\/p>\n

This guide shows you how to make a line graph in Google Sheets with a single line and with multiple lines, and then how to customize it. You’ll also see the three line chart types in Google Sheets and how to add a vertical line that marks a date on the chart.<\/p>\n

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

What is a line graph in Google Sheets?<\/h2>\n

Google Sheets offers various types of charts to visualize your data. One of these is the line graph, which is ideal for illustrating changes to one or more variables over time. Usually, the X-axis shows the time units, while the Y-axis shows the units of the other variables.<\/p>\n

If you want to visualize a single variable to see how it changes over time, you can use a line graph with a single line. However, you can easily show multiple lines on the same line graph, provided they are in the same units.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”how-to-make-a-line-graph-in-google-sheet” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to make a line graph in Google Sheets<\/h2>\n

Follow these steps to make a line graph with one line or with several lines.<\/p>\n

Make a line graph with a single line<\/h3>\n

Let’s start by creating a single line graph in Google Sheets, showing changes to Apple\u2019s closing price in January.<\/p>\n

1.<\/strong> Open Google Sheets to the file with your data.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/line-graph-google-sheets-stock-price-data.webp” alt=”Line graph in Google Sheets \u2014 AAPL closing prices by date in columns A and B” title_text=”AAPL closing prices by date in columns A and B” 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> Select the data you want to include in the line graph. In this case, it\u2019s the date and stock price data.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/line-graph-google-sheets-select-data.webp” alt=”Make a line graph in Google Sheets \u2014 Date and AAPL Close\/Last columns selected in A1:B12″ title_text=”Date and AAPL Close\/Last columns selected in A1:B12″ 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> Go to Insert > Chart.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/line-graph-google-sheets-insert-chart.webp” alt=”Make a line graph in Google Sheets \u2014 Chart option in the Insert menu” title_text=”Chart option in the Insert menu” 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> Google Sheets usually recognizes the type of data and selects the appropriate chart type. However, if it doesn\u2019t, go to the \u2018Chart editor\u2019 sidebar and select the \u2018Line chart\u2019 under \u2018Chart type\u2019.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/line-graph-google-sheets-line-chart-type.webp” alt=”Google Sheets line graph \u2014 Line chart picked under Chart type for the AAPL Close\/Last vs. Date chart” title_text=”Line chart picked under Chart type for the AAPL Close\/Last vs. Date 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

5.<\/strong> You can edit and customize the chart by right-clicking on the chart or from the ‘Customize’ tab in the ‘Chart editor’. The section on how to customize a line graph, further down, covers the main options.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/line-graph-google-sheets-customize-tab.webp” alt=”Google Sheets line graph \u2014 right-click Edit menu on the chart and the Customize tab options” title_text=”Right-click Edit menu on the chart and the Customize tab options” 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

Make a line graph with multiple lines<\/h3>\n

Now that you know how to make a single-line graph, let\u2019s see how to create one with multiple lines. Let\u2019s add two more lines to the line graph created in the previous section: the closing prices for Microsoft and Cisco.<\/p>\n

1.<\/strong> Open the spreadsheet with your data in Google Sheets.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/line-graph-multiple-lines-stock-data.webp” alt=”Line graph with multiple lines in Google Sheets \u2014 AAPL, MSFT, and CSCO closing prices by date” title_text=”AAPL, MSFT, and CSCO closing prices by date” 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> Select the data you want to include. In this case, the date and the three stock prices.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/line-graph-multiple-lines-select-data.webp” alt=”Line graph with multiple lines in Google Sheets \u2014 date and three stock price columns selected in A1:D12″ title_text=”Date and three stock price columns selected in A1:D12″ 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> Go to Insert > Chart.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/line-graph-multiple-lines-insert-chart.webp” alt=”Line graph with multiple lines in Google Sheets \u2014 Chart option in the Insert menu” title_text=”Chart option in the Insert menu” 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> If Google Sheets doesn\u2019t do it automatically, select \u2018Line chart\u2019 under \u2018Chart type\u2019 from the sidebar.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/line-graph-multiple-lines-line-chart.webp” alt=”Line graph with multiple lines in Google Sheets \u2014 three stock price lines with Line chart set under Chart type” title_text=”Three stock price lines with Line chart set under 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

5.<\/strong> As you can see, this graph has three lines: one for each stock price. You can add or remove series or lines from the \u2018Setup\u2019 tab in the \u2018Chart editor\u2019.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/line-graph-multiple-lines-series.webp” alt=”Line graph with multiple lines in Google Sheets \u2014 Series list with AAPL, MSFT, and CSCO and the Add Series button” title_text=”Series list with AAPL, MSFT, and CSCO and the Add Series button” 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> To customize or edit the chart, use the \u2018Customize\u2019 tab in the \u2018Chart editor\u2019 or right-click on the chart to see a menu.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/line-graph-multiple-lines-customize-tab.webp” alt=”Line graph with multiple lines in Google Sheets \u2014 right-click Edit menu on the chart and the Customize tab” title_text=”Right-click Edit menu on the chart and the Customize tab” 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

How to customize a line graph in Google Sheets<\/h2>\n

To change how your line graph looks, double-click it and open the Customize tab in the Chart editor. The screenshots in this section use a different example, yearly revenue for three branches, but the options are the same for any line graph.<\/p>\n

    \n
  1. Open Chart style to change the background color, the font, and the chart border color.<\/li>\n<\/ol>\n

    [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/09\/How-to-make-a-line-graph-in-Google-Sheets-5.webp” alt=”Customize a line graph in Google Sheets \u2014 Chart style options with a gray background on the branch revenue chart” title_text=”Chart style options with a gray background on the branch revenue 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

      \n
    1. Open Chart & axis titles, choose Chart title, and type the title. You can also set its font, size, format, and color.<\/li>\n<\/ol>\n

      [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/09\/How-to-make-a-line-graph-in-Google-Sheets-6.webp” alt=”Customize a line graph in Google Sheets \u2014 chart title Revenue in Roboto, size 30, bold and dark blue” title_text=”Chart title Revenue in Roboto, size 30, bold and dark blue” 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

        \n
      1. Open Series to change the color, opacity, dash type, and thickness of the lines. To show a marker on each data point, pick a point size and a point shape.<\/li>\n<\/ol>\n

        [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/09\/How-to-make-a-line-graph-in-Google-Sheets-7.webp” alt=”Google Sheets line graph markers \u2014 Series options with a 10px circle point on all three lines” title_text=”Series options with a 10px circle point on all three lines” 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

          \n
        1. Open Legend to move the legend, for example to the bottom of the chart, and to set its font, size, and color.<\/li>\n<\/ol>\n

          [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/09\/How-to-make-a-line-graph-in-Google-Sheets-8.webp” alt=”Customize a line graph in Google Sheets \u2014 Legend position set to Bottom with font size 16″ title_text=”Legend position set to Bottom with font size 16″ 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

            \n
          1. Open Vertical axis and set Min and Max. When the lines sit close together, a tighter range spreads them out. In this example, a range of 4 million to 11 million instead of 0 to 12.5 million makes the differences between the branches easier to see.<\/li>\n<\/ol>\n

            [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/09\/How-to-make-a-line-graph-in-Google-Sheets-9.webp” alt=”Customize a line graph in Google Sheets \u2014 Vertical axis Min 4000000 and Max 11000000″ title_text=”Vertical axis Min 4000000 and Max 11000000″ 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

              \n
            1. Open Gridlines and ticks to add or remove gridlines and ticks. Here, the major gridlines of the vertical axis are turned off, which removes the horizontal lines across the chart.<\/li>\n<\/ol>\n

              [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/09\/How-to-make-a-line-graph-in-Google-Sheets-10.webp” alt=”Customize a line graph in Google Sheets \u2014 Gridlines and ticks for the vertical axis with Major gridlines unchecked” title_text=”Gridlines and ticks for the vertical axis with Major gridlines unchecked” 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 module_id=”how-to-make-a-line-chart-in-google-sheet” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

              How to make a line chart in Google Sheets<\/h2>\n

              To make a line chart in Google Sheets, pick one of the three options under Line in the Chart type menu: line chart, smooth line chart, or combo chart.<\/p>\n

              [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/line-chart-google-sheets-chart-types.webp” alt=”Line chart in Google Sheets \u2014 Line chart, Smooth line chart, and Combo chart options in the Chart type menu” title_text=”Line chart, Smooth line chart, and Combo chart options in the Chart type menu” 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

              Let\u2019s see how the line chart and the smooth line chart differ by creating each type for the same set of variables, which include year, revenue, and net income. Finally, you will see how to use a combo chart to represent change over time using bars for one variable and a line for the other.<\/p>\n

              Line chart<\/h3>\n

              Follow the steps below to create a line chart showing changes to revenue and net income over time.<\/p>\n

              1.<\/strong> Open Google Sheets to the file containing your data.<\/p>\n

              [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/line-chart-google-sheets-revenue-data.webp” alt=”Line chart in Google Sheets \u2014 yearly revenue and net income from 2012 to 2022″ title_text=”Yearly revenue and net income from 2012 to 2022″ 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> Select the data you want to include and go to Insert > Chart.<\/p>\n

              [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/line-chart-google-sheets-insert-chart.webp” alt=”Line chart in Google Sheets \u2014 revenue data selected and the Chart option in the Insert menu” title_text=”Revenue data selected and the Chart option in the Insert menu” 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> Make sure that the chart type is \u2018Line chart\u2019.<\/p>\n

              [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/line-chart-google-sheets-revenue-net-income.webp” alt=”Line chart in Google Sheets \u2014 Revenue and Net income lines with Line chart set under Chart type” title_text=”Revenue and Net income lines with Line chart set under 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> As you can see below, each data point is represented by a marker, and these are joined by straight lines.<\/p>\n

              [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/line-chart-google-sheets-markers.webp” alt=”Line chart in Google Sheets \u2014 data point markers joined by straight lines, highlighted on the Revenue line” title_text=”Data point markers joined by straight lines, highlighted on the Revenue line” 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

              Smooth line chart<\/h3>\n

              Follow the steps below to create a smooth line chart showing the same data as the previous example: revenue and net income over time.<\/p>\n

              1.<\/strong> Using the chart from the previous example, go to the \u2018Setup\u2019 tab in the \u2018Chart editor\u2019.<\/p>\n

              [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/smooth-line-chart-google-sheets-setup-tab.webp” alt=”Smooth line chart in Google Sheets \u2014 Setup tab of the Chart editor highlighted” title_text=”Setup tab of the Chart editor highlighted” 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> Under \u2018Chart type\u2019, change the selection to \u2018Smooth line chart\u2019.<\/p>\n

              [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/smooth-line-chart-google-sheets-chart-type.webp” alt=”Smooth line chart in Google Sheets \u2014 Smooth line chart picked under Chart type” title_text=”Smooth line chart picked under 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

              3.<\/strong> As you can see, the lines joining the data markers are now smooth, which means the chart shows a slightly distorted view of reality. You should be especially careful using this type of chart with small datasets, as the distortion will be greater.<\/p>\n

              [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/smooth-line-chart-vs-line-chart-google-sheets.webp” alt=”Smooth line chart in Google Sheets \u2014 line chart and smooth line chart side by side for the same data” title_text=”Line chart and smooth line chart side by side for the same data” 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

              Combo chart<\/h3>\n

              Finally, let\u2019s see how you can use the combo chart to represent each variable using a different method: one variable is represented by bars, while the other is represented by markers joined by a line. Follow the instructions below to make a combo chart showing revenue and net income over time.<\/p>\n

              1.<\/strong> Open the spreadsheet with your data in Google Sheets.<\/p>\n

              [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/combo-chart-google-sheets-revenue-data.webp” alt=”Combo chart in Google Sheets \u2014 yearly revenue and net income table” title_text=”Yearly revenue and net income table” 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> Select the data you want to include and go to Insert > Chart.<\/p>\n

              [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/combo-chart-google-sheets-insert-chart.webp” alt=”Combo chart in Google Sheets \u2014 data in A1:C12 selected and the Chart option in the Insert menu” title_text=”Data in A1:C12 selected and the Chart option in the Insert menu” 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> Select the \u2018Combo chart\u2019 from the \u2018Chart editor\u2019. Revenue is represented by the blue bars and net income by the red line.<\/p>\n

              [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/combo-chart-google-sheets-revenue-net-income.webp” alt=”Combo chart in Google Sheets \u2014 revenue as blue columns and net income as a red line” title_text=”Revenue as blue columns and net income as a red line” 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 module_id=”how-to-add-a-vertical-line-to-a-google-s” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

              How to add a vertical line to a Google Sheets chart<\/h2>\n

              Google Sheets has no setting that draws a vertical line on a chart, for example to mark a launch date or the start of a quarter. You can get one with a helper column and a combo chart.<\/p>\n

                \n
              1. Add a helper column next to your data.<\/li>\n
              2. In the row of the date you want to mark, enter a value at least as high as the largest value in the chart. Leave the other cells of the helper column empty.<\/li>\n
              3. Select the data, including the helper column, and go to Insert > Chart.<\/li>\n
              4. In the Setup tab of the Chart editor, set Chart type to Combo chart.<\/li>\n
              5. Open the Customize tab, click Series, and pick the helper series. Set its Type to Columns, and set every other series to Line.<\/li>\n
              6. Under Vertical axis, set Max to the value you entered in the helper column, so the column reaches the top of the chart.<\/li>\n<\/ol>\n

                The helper series now shows as a single thin column at the date you picked, which reads as a vertical line. The column gets thinner as you add rows, so this works best with daily or weekly data. The helper series also appears in the legend, so give its header a clear label, such as Launch.<\/p>\n

                [\/et_pb_text][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

                Conclusion<\/h2>\n

                As you have seen, line graphs are a great way to visualize changes to variables over time. You can create graphs showing one or multiple variables to see the evolution of each and easily compare them. While using a smooth line chart may look a little prettier, you should be careful not to use it with very small datasets, as manipulating the data in this way can lead to a distorted view.<\/p>\n

                You now know what line graphs are and how to use them in Google Sheets. You have step-by-step instructions on how to create a line graph using a single line or variable, as well as how to make one using multiple lines to represent different variables. You also know how to customize the chart, how the three line chart types in Google Sheets differ (line chart, smooth line chart, and combo chart), and how to mark a date with a vertical line. Finally, you\u2019ve seen examples of line charts showing changes to stock closing prices, as well as revenue and net income over time.<\/p>\n

                To learn more about tables and charts in Google Sheets, check out these guides:<\/p>\n