Unbelievable Make Line Graph In Google Sheets

About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy Safety How YouTube works Test new features Press Copyright Contact us Creators.

Make line graph in google sheets. Occasionally you may want to add a horizontal line to a chart in Google Sheets to represent a target line an average line or some other metric. Im trying to add a vertical line to a chart in Sheets for visual purposes. Google Sheets gave us an auto option which was the LINE CHART itself this time.

You can change it over to Scatter Chart by double-clicking on the Chart and picking Chart Editor. After data selection go to the menu of Google Sheets and select Insert and the Chart. Once in Chart Editor you can simply choose the Chart Type as Scatter Plot.

A similar question was asked previously but I didnt see a reply. This tutorial is a straightforward guide to inserting a line chart in Google Sheets with some notes on the type of data that it requires you to have. For this example well create the following fake dataset that shows the total sales and the goal for.

Select all three columns down to the last row of data. For example in the below sheet we have selected a complete data range of G column ie Total. Jump into your Google Sheets and then enter the data that you want to use for your line chart.

Create a Line graph in Google Sheets. How to Add a Target Line Across a Column Chart in Google Sheets. Google Sheets will create a default chart.

Copy and paste the data that is provided above into your spreadsheet in cell A1 Click Insert on the top toolbar menu and then click Chart to open the chart editor Select Line Chart from the Chart type drop-down menu. Create a Basic Column Chart with Horizontal Target Line in Sheets. How to Create a Line Chart in Google Sheets.