Step 1: Open the Google Sheets file

Open the Google Sheet containing the data you want to use to create your line chart.

Step 2: Select the dataset

Click and drag to select the dataset that you want to include in your line chart. Ensure that you choose both the independent variable (usually on the X-axis) and the dependent variable (usually on the Y-axis).

Step 3: Open the chart editor

With your data selected, go to the "Insert" menu at the top of the Google Sheets interface. Click on "Chart" in the dropdown menu. This will open the chart editor sidebar on the right side of your spreadsheet.

Step 4: Choose to create a line chart

In the chart editor, you'll see different chart types. Choose "Line chart" from the list of options.

Step 5: Move the line chart to its own sheet (optional)

If you want to edit your line chart without distractions, you can move it to another sheet by clicking on the three vertical dots at the top right of the chart and selecting “move to own sheet.” Google Sheets will automatically create a new sheet, called “Chart 1,” where you can then view and edit your chart.

Step 6: Customize the chart

The chart editor allows you to customize various aspects of your line chart. You can access it by clicking on the “Edit chart” button on the line chart’s menu.

Step 6.1: Change the chart’s title

In the chart editor, under "Chart & axis titles," select “Chart Title” in the dropdown list. There, you can type a new title and choose your preferred font, size, format, and text color, to make your chart more visually appealing.

Step 6.2: Change the horizontal or vertical axis title

Similarly, click the "Horizontal axis title" and "Vertical axis title" options to label the X and Y axes. Remember that you can change the font, size, format, and text color, to make your chart more visually appealing.

Step 6.3: Change chart style

In the chart editor, go to the Chart Style section. There, you can change the background color by clicking on the option under "Background Color." You can also modify the font and the color of the border.

Step 6.4: Edit the series

In the Customize tab of the chart editor, scroll down until you see the Series section. Click on the dropdown under the name of the section to start editing the line chart’s appearance.

You can adjust various properties such as line style, line thickness, marker style, and color. For example, you can change the line style to make it solid, dashed, or dotted, modify the line thickness, add markers at data points, choose a specific color for the series, and add a data label.

Step 7: Share it

If you’re done with your line chart, you can share it with whomever you want, by clicking on the “Share” button. Alternatively, you can publish or download the chart.

Step 1: Log in to Softr or create an account

First, you will need to login to Softr. If you don’t have an account, you can sign up to Softr for free.

Step 2: Click on “New Application”

Softr offers a wide variety of templates that can simplify the process of creating apps with data stored in Google Sheets. To access these templates, click on “New Application".

Step 3: Create a blank application

Because you want to make something as simple as a line chart, click on the button to create a blank application.

Step 4: Select prebuilt pages

Again, because all you need is a page to create a line chart, deselect all pages, except the Home. Then click on “Create application.”

Step 5: Connect Softr and Google Sheets

In order for you to create a line chart in Softr using your Google Sheets data, you first need to connect these two products. To do so, follow the below steps.

Step 5.1: Choose Google Sheets as the data source

Now, you need to allow Softr to access your data in Google Sheets so that you can then create a line chart based on it. To do so, click on “Google Sheets” and then on “Continue.”

Step 5.2: Log in to your Google account

Now you need to specify in which Google account your Google Sheets file is in. You can do so by logging in to that Google account.

Step 5.3: Authorize Softr

Next, authorize Softr to make changes in your Google Sheets and Google Drive files, by ticking the two boxes highlighted in the image below. Then click on “Continue.”

Step 6: Delete all blocks

Before you create your line chart, hover on each prebuilt block and delete all of them, so that you end with a blank canvas in which you can start building.

Step 7: Access the list of premade blocks

Softr offers a wide list of premade blocks, including line charts. To access them, click on the “+” sign at the top right corner of your screen or on the “Add your first block” button.

Step 8: Choose to create a line chart

Once the block menu slides in, type “line chart” and click on the respective block to select it.

Note that, although you can’t use the line chart on the free version, you can use it once you activate the 30-day trial version. You won’t get charged until after 30 days, so you can cancel your subscription at any time.

Step 9: Choose from which Google Sheet file you want to import the data

Head over to the Source tab and locate the “Connect data source” button. Click on it and choose your connected Google Sheets account. From there, you’ll be presented with a list of Google Sheets files to choose from. Once you’ve found the one with the data you need, select it and then choose the specific sheet you want to import data from.

Step 10: Customize your line chart

Go to the features bar and make changes to your line chart the way you want.

Step 10.1: Change the title and subtitle

Type the title and subtitle you want in the text box under each respective heading.

Step 10.2: Update metrics

To ensure the data from your connected Google Sheets spreadsheets is displayed in the pie chart, go to the metrics section just below the title and subtitle. There, choose the aggregate function “Sum”, and under “Field,” select your main value (Organic Traffic, in our case). Under “Groupings,” select the field in which we want our metric to be grouped (Year, in our case).



Step 10.3: Change the styling

You can change the background color and add border lines to the top and bottom of your chart using the “styles” bar.

Step 10.4: Change the access permissions

To update the access permissions, go to the Visibility tab. The default setting there is “All users,” which means everyone can see the chart when it is published, whether they are logged in or not.

If you want only logged-in users to access the data, click on the dropdown and select “logged-in users.” Alternatively, if you want only non-logged-in users to view the pie chart, select “Non-logged-in users.”

Step 11: Test and optimize

Click on the “Preview” button to see how the pie chart looks before sharing it with others.

Step 12: Share your line chart

Once you’ve finished tinkering with your line chart, you can now click on the “Publish” button to save all the changes and share them with others.