{"id":44606,"date":"2023-09-28T00:32:19","date_gmt":"2023-09-27T22:32:19","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=44606"},"modified":"2025-12-17T22:07:43","modified_gmt":"2025-12-17T21:07:43","slug":"como-hacer-un-grafico-lineal-en-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/es\/blog\/google-sheets-features\/how-to-make-a-line-graph-in-google-sheets\/","title":{"rendered":"C\u00f3mo hacer un gr\u00e1fico lineal en 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’re looking for a step-by-step guide on how to make a line graph in <\/span>Google Sheets<\/span><\/a>, you’ve come to the right place. Whether you’re a beginner or a seasoned spreadsheet user, you’ll learn how to leverage charts and graphs to build reports and dashboards.<\/span><\/p>\n

In this article, you’ll understand what a line graph is, the advantages of using line graphs and its key features. In addition, we\u2019ll walk you through the process of creating eye-catching line charts.<\/span><\/p>\n

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

What are line graphs?<\/span><\/h2>\n

Line graphs, also known as line charts, are a visual representation of data points connected by straight lines. They’re particularly effective for displaying trends and variations over a continuous interval or time period. By plotting data points on a graph and connecting them with lines, line graphs provide a clear picture of how values change over time.<\/span><\/p>\n

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

What are the advantages of using line graphs?<\/span><\/h2>\n

There are many advantages to using line graphs. Some of the advantages include:<\/span><\/p>\n

Clarity<\/b>: the continuous lines connecting data points provide a clear visual representation of how values are changing, making it easy for viewers to identify patterns.<\/span><\/p>\n

Simplicity<\/b>: line graphs are simple and intuitive. The concept of connecting points with lines to show trends is easy for a wide audience to understand, making them an ideal choice for presenting complex data in a digestible format.<\/span><\/p>\n

Effective communication tool<\/b>: line graphs serve as powerful communication tools, allowing data analysts, researchers, and presenters to convey complex information in a visually compelling and accessible manner.\u00a0<\/span><\/p>\n

Continuous data representation<\/b>: the smooth lines create a visual flow that enhances the understanding of the data’s progression. For this reason, line graphs are particularly well-suited for representing continuous data, such as changes over time.<\/span><\/p>\n

Prediction and projections<\/b>: by extrapolating trends displayed on a line graph, users can make informed predictions and projections about future values. In other words, you can benefit from this forecasting ability in various fields, including finance, sales, and scientific research.<\/span><\/p>\n

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

Key features of line graphs<\/span><\/h2>\n

Before we delve into creating line graphs in Google Sheets, let’s explore some key features that make them an essential tool for data representation.<\/span><\/p>\n

Data points<\/b>: individual data points represent specific values and are plotted on the graph at corresponding positions. These points serve as the building blocks for the lines that connect them.<\/span><\/p>\n

X and Y-axis<\/b>: line graphs have an x-axis (horizontal) and a y-axis (vertical). While the x-axis typically represents time or categories, the y-axis represents the values being measured.<\/span><\/p>\n

Lines<\/b>: lines connect the data points, providing a visual representation of the trends in the data.\u00a0<\/span><\/p>\n

Markers<\/b>: markers on data points or lines enhance visibility. They make it easier to pinpoint specific values and add an extra layer of detail to your graph.<\/span><\/p>\n

[\/et_pb_text][et_pb_text module_id=”how” _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<\/span><\/h2>\n

After going over the advantages of using line graphs and their key features, let\u2019s learn how to make a line graph in Google Sheets.<\/span><\/p>\n

In this example, we\u2019ll use a spreadsheet that contains the annual revenue from 3 branches (Ridgewood, Barclays and Woodside) over the course of 10 years.<\/span><\/p>\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-1.webp” alt=”How to make a line graph in Google Sheets 1″ title_text=”How to make a line graph in Google Sheets 1″ 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

I’ll show you how to make a line graph to compare the revenue for each branch over the years. Click <\/span>Insert<\/b> and select <\/span>Chart<\/b>.<\/span><\/p>\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-2.webp” alt=”How to make a line graph in Google Sheets 2″ title_text=”How to make a line graph in Google Sheets 2″ 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 we can start building the line chart. Select <\/span>Line chart<\/b>. Then add the <\/span>X-axis<\/b> and the <\/span>Series<\/b>. First, I’ll create a chart that shows the revenue from one of the branches.\u00a0<\/span><\/p>\n

Here, the line graph shows a single series of data.<\/span><\/p>\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-3.webp” alt=”How to make a line graph in Google Sheets 3″ title_text=”How to make a line graph in Google Sheets 3″ 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

However, you can also create line graphs that show multiple series of data. By adding multiple series of data, I can compare the revenue from all the branches.<\/span><\/p>\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-4.webp” alt=”How to make a line graph in Google Sheets 4″ title_text=”How to make a line graph in Google Sheets 4″ 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

Customize your chart<\/span><\/h3>\n

After creating the graph, we can customize it to our liking. First, I’ll change the background color.<\/span><\/p>\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=”How to make a line graph in Google Sheets 5″ title_text=”How to make a line graph in Google Sheets 5″ 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 I’ll add a title, select a font and change the text color.<\/span><\/p>\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=”How to make a line graph in Google Sheets 6″ title_text=”How to make a line graph in Google Sheets 6″ 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

When I click on <\/span>Series<\/b>, I can edit the lines to customize the color, dash type, thickness, and so on. I’ll add markers to the line plot.<\/span><\/p>\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=”How to make a line graph in Google Sheets 7″ title_text=”How to make a line graph in Google Sheets 7″ 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

By selecting <\/span>Legend,<\/b> I can customize the legend font, size, format and color. I can also choose where I’ll place it. In this example, I will move the legend to the bottom of the graph.<\/span><\/p>\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=”How to make a line graph in Google Sheets 8″ title_text=”How to make a line graph in Google Sheets 8″ 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

In order to help readers better compare the different data series in the line chart, I will need to change the scale of the vertical axis.\u00a0<\/span><\/p>\n

Currently, the axis ranges from 0 to 12.5 million, which compresses the lines and makes it harder to see the contrasts and differences between the values. To improve this, I will set the minimum value on the vertical axis to 4 million and the maximum value to 11 million.\u00a0<\/span><\/p>\n

Expanding the scale in this way will spread out the data lines and make it easier to analyze the variations between each series. As a result, this will highlight the peaks, valleys, and overall patterns in each line, enabling readers to quickly grasp where one series is rising while another is declining. This is a simple yet effective way to improve the readability of this multi-series line chart.<\/span><\/p>\n

As you can see, it is now much easier to visualize the contrast between the multiple series.<\/span><\/p>\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=”How to make a line graph in Google Sheets 9″ title_text=”How to make a line graph in Google Sheets 9″ 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 we can add, remove and format the gridlines and ticks. I’ll remove the major gridlines.<\/span><\/p>\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=”How to make a line graph in Google Sheets 10″ title_text=”How to make a line graph in Google Sheets 10″ 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

Last but not least, I’ll switch to an area chart to make it more visually appealing.<\/span><\/p>\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-11.webp” alt=”How to make a line graph in Google Sheets 11″ title_text=”How to make a line graph in Google Sheets 11″ 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=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Conclusion<\/span><\/h2>\n

There you have it! With just a few clicks, we have built a line graph, adding multiple series and customizing it to make it easier for readers to analyze and interpret the chart.<\/span><\/p>\n

If you want to create a bar graph instead, check out this article on <\/span>how to create a bar chart in Google Sheets<\/span><\/a>.<\/span><\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

If you’re looking for a step-by-step guide on how to make a line graph in Google Sheets, you’ve come to the right place. Whether you’re a beginner or a seasoned spreadsheet user, you’ll learn how to leverage charts and graphs to build reports and dashboards. In this article, you’ll understand what a line graph is, […]<\/p>\n","protected":false},"author":42,"featured_media":43848,"comment_status":"closed","ping_status":"closed","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":[39,28],"class_list":["post-44606","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/44606","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/42"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=44606"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/44606\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/43848"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=44606"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=44606"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=44606"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}