How to Make a Line Graph in Google Sheets with Multiple Lines

One of the really cool things about using Google sheets is you can easily convert your data into live graphs. If you want to visually display your data, line graphs with multiple lines are a great tool to use. You might also find this useful if you're using Google sheets to track historical stock data, combining multiple sheets into one master sheet, and more


For this example, let's pretend we are tracking our inventory of fruit by quantity available and sale price.




Step 1: Create your data table

The first thing we need to do is compile all of the data into a table. For this example, my first column will be all of the fruit names, the second column will be quantity, and the third column will be price. It should look something like this:



Step 2: Create the chart

To create the chart, you're simply going to click Insert > Chart in the top toolbar.


You will see a box for your chat pop up (it will say No Data at first) and the Chart Editor on the right-hand side, like this:



Now we begin the fun stuff... let's start making this chart!



Step 3: Populate chart data

Now we're going to start using the editor to populate the data.


First, let's change the Chart type to Line Chart (this will likely be the first option in the dropdown).


Next, we're going to select our data range. Click on the four squares to the right of Data range. You'll see a small popup box where you can either type in the range or select it on the screen. Then click OK.