Make a Line Graph in Google Sheets - - Windows Tips and Tricks with Geek

Thursday, November 18, 2021

Make a Line Graph in Google Sheets

 Google Sheets Line Chart

Make a Line Chart in Google Sheets

Start by selecting your data. You can do this by dragging your cursor through the range of cells you want to use.

Select the data

Go to Insert in the menu and select “Chart.”

Click Insert, Chart

Google Sheets pops a default style graph into your spreadsheet, normally a column chart. But you can change this easily.

When the graph appears, the Chart Editor sidebar should open along with it. Select the “Setup” tab at the top and click the “Chart Type” drop-down box. Move down to the Line options and pick the one you want from a standard or smooth line chart.

Select a Line chart style

The graph on your sheet will update immediately to the new chart type. From there, you can customize it if you like.

Line graph in Google Sheets

Customize a Line Graph in Google Sheets

Most types of charts you create in Google Sheets have the same customization options. So you can do things like change the title, choose a background color, or give your graph a border.

If you closed the Chart Editor sidebar, reopen it by clicking the three dots on the top right of the chart and picking “Edit Chart.”

Select Edit Chart

In the sidebar, select the Customize tab at the top. You’ll then see all of your options listed and collapsed. This lets you can expand only what you need or one at a time.

View the Customize tab

Let’s take a look at a few customization options particular to line charts.

Adjust the Series

For each series on your chart, you have a colored line. Maybe you’d like to change these colors, adjust the thickness, or choose a different line type.

Expand Series in the sidebar. To change each series individually, select the drop-down for Apply to All Series and pick the one you want to adjust first.

Select a series

You might change the color for that line or select a point shape. You’ll see any changes you make apply to your line graph immediately.

Change a series style

If you want to make an adjustment that applies to all, such as changing the line thickness, select “Apply to All Series” once more and make your changes.

Apply changes to all series

Change the Gridlines and Ticks

Another adjustment you may want to make to your line chart is for the gridlines and ticks. Expand that area in the sidebar to view your options.

Expand Gridlines and Ticks

For the horizontal axis, you can only change the major ticks. But for the vertical axis, you can adjust both major and minor gridlines and ticks. You can choose a different color for the gridlines and select a position, length, thickness, and color for the ticks.

Change gridlines and ticks

Modify the Legend

Although you can change the legend for other types of charts in Google Sheets, it’s something else you may want to modify for your line graph.

Expand “Legend” in the sidebar. You can then change the position along with the font style, size, format, and color.

Change the legend

If you don’t want to use a legend at all, select “None” in the Position drop-down list.

Select None to remove the legend

Because it’s so simple to make a line graph in Google Sheets, you can give your sheet some pizzazz or your viewers an easy way to see your data at a glance.

No comments:

Post a Comment