# how to make a line graph in google sheets

Viewport: 1910x922 @1.125x

Playback: autoplay=false durationMs=3000 navBar=false arrows=true callouts=true browserBar=false browserTheme=light

1. [Intro] How to Create a Line Graph in Google Sheets
   - body: This guide will take you through the process of creating a line graph in Google Sheets. Follow these steps to visualize your data effectively.
   - voiceover: Follow these step-by-step instructions to create a line graph using Google Sheets. You will learn how to select your data, insert a chart, and customize it to fit your needs.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8orxkz7005ijr0c391inp7p/cm8os5tt700200cl71gaz5vbz.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
1. step_01 [image] - Click here to open Google Sheets in your web browser.
   - source type: IMAGE
   - description: Open Google Sheets
   - target: (502.59031121141754, 337.3865802165306), rect: top=165.7777862548828 left=46 width=1640 height=604
   - hotspots: 1
     - hotspot_01 (502.59031121141754, 337.3865802165306), rect: top=165.7777862548828 left=46 width=1640 height=604
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Click here to open Google Sheets in your web browser.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8orxkz7005ijr0c391inp7p/cm8os5yi800220cl7h8ffhr1z.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8orxkz7005ijr0c391inp7p/cm8orxt8w000103hugukzqmw5.png
2. step_02 [image] - Click and drag to select the range of cells that contain the data you want to include in your line graph.
   - source type: IMAGE
   - description: Select the Data
   - target: (124, 201), rect: top=165.7777862548828 left=46 width=1640 height=604
   - hotspots: 1
     - hotspot_01 (124, 201), rect: top=165.7777862548828 left=46 width=1640 height=604
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Click and drag to select the range of cells that contain the data you want to include in your line graph. Make sure all relevant data is captured.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8orxkz7005ijr0c391inp7p/cm8os5yiz00230cl78d2b1ufi.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8orxkz7005ijr0c391inp7p/cm8orxtlp000203hucouv93z8.png
3. step_03 [image] - Click on the 'Insert' menu at the top of the page, then select 'Chart' from the dropdown menu.
   - source type: IMAGE
   - description: Insert Chart
   - target: (188.5940209830553, 70.26606583701357), rect: top=34 left=179.6527862548828 width=53.63888931274414 height=23.55555534362793
   - hotspots: 1
     - hotspot_01 (188.5940209830553, 70.26606583701357), rect: top=34 left=179.6527862548828 width=53.63888931274414 height=23.55555534362793
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Click on the 'Insert' menu at the top of the page, then select 'Chart' from the dropdown menu. This will open the Chart Editor panel on the right side of the screen.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8orxkz7005ijr0c391inp7p/cm8os5yjq00240cl759jlc2gf.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8orxkz7005ijr0c391inp7p/cm8orxwfc000303huje8pn68v.png
4. step_04 [image] - In the Chart Editor panel that appears on the right, click on the 'Chart type' dropdown menu and select 'Line chart'.
   - source type: IMAGE
   - description: Choose Chart Type
   - target: (445, 272), rect: top=264.6666564941406 left=218.5416717529297 width=267 height=20
   - hotspots: 1
     - hotspot_01 (445, 272), rect: top=264.6666564941406 left=218.5416717529297 width=267 height=20
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: In the Chart Editor panel, click on the 'Chart type' dropdown menu and select 'Line chart'. This will change the default chart to a line graph.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8orxkz7005ijr0c391inp7p/cm8os5ykg00250cl7epned0tm.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8orxkz7005ijr0c391inp7p/cm8orxycx000403hupv4yssfs.png
5. step_05 [image] - Use the customization options in the Chart Editor to adjust the appearance and settings of your line graph as desired.
   - source type: IMAGE
   - description: Save Chart
   - target: (1377.1037185228022, 279.07909108035005), rect: top=298.8888854980469 left=1388.27783203125 width=114 height=80
   - hotspots: 1
     - hotspot_01 (1377.1037185228022, 279.07909108035005), rect: top=298.8888854980469 left=1388.27783203125 width=114 height=80
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Use the customization options in the Chart Editor to adjust the appearance and settings of your line graph as desired. Options include chart title, axis labels, and colors.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8orxkz7005ijr0c391inp7p/cm8os5yla00260cl7hwjleq6k.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8orxkz7005ijr0c391inp7p/cm8ory5rp000603hudtq7qov7.png
6. step_06 [image] - Here you have your Line Chart.
   - source type: IMAGE
   - description: Insert Chart into Sheet
   - target: (988.9349708824071, 351.8910588141939), rect: top=165.7777862548828 left=46 width=1640 height=604
   - hotspots: 1
     - hotspot_01 (988.9349708824071, 351.8910588141939), rect: top=165.7777862548828 left=46 width=1640 height=604
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Here you have your Line Chart. Review the chart to ensure it accurately represents your data.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8orxkz7005ijr0c391inp7p/cm8os5ym000270cl720quhjv3.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8orxkz7005ijr0c391inp7p/cm8ory6tb000703hut3ky2x7k.png
8. [Outro] Congrats 🎉
   - body: You have successfully created a line graph in Google Sheets. You can now further customize your chart, add labels, or share your sheet with others for collaboration.
   - voiceover: You can now save, share, or embed your new line graph in your documents or presentations. Explore additional customization options in Google Sheets to further enhance your chart.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8orxkz7005ijr0c391inp7p/cm8os5v7f00210cl76eokat0c.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM

Source: https://share.layerpath.com/share/cm8orxkz7005ijr0c391inp7p/tour