# how to make a 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 Graph in Google Sheets
   - body: Follow these step-by-step instructions to create a graph in Google Sheets. This guide will help you visualize your data effectively within the spreadsheet tool.
   - voiceover: This guide walks you through the steps to create a graph in Google Sheets. Follow these easy steps to visualize your data effectively.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8okhceh0097l40cevnfiiwa/cm8okueay00020cjr56y58p2g.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
1. step_01 [image] - Open Google sheets then insert the data for table. 
   - source type: IMAGE
   - description: Open Google Sheets and select your data
   - target: (580, 286), rect: top=165.7777862548828 left=46 width=1640 height=604
   - hotspots: 1
     - hotspot_01 (580, 286), rect: top=165.7777862548828 left=46 width=1640 height=604
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Open Google Sheets and insert the data for your table. Enter the data you want to visualize in the cells.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8okhceh0097l40cevnfiiwa/cm8okujb700040cjr8f6z0vdt.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8okhceh0097l40cevnfiiwa/cm8okhglh000003hugrztp1in.png
2. step_02 [image] - Drag the data for table.
   - source type: IMAGE
   - description: Insert Chart
   - target: (70, 172), rect: top=165.7777862548828 left=46 width=1640 height=604
   - hotspots: 1
     - hotspot_01 (70, 172), rect: top=165.7777862548828 left=46 width=1640 height=604
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Drag your mouse over the data range you want to include in the chart. Make sure to select all the relevant cells.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8okhceh0097l40cevnfiiwa/cm8okujbq00050cjr9xocfjr9.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8okhceh0097l40cevnfiiwa/cm8okhhbt000103hu9u32h1re.png
3. step_03 [image] - Click Insert in the top menu.
   - source type: IMAGE
   - description: Choose Chart Type
   - target: (188.56379356751887, 67.43621721558371), rect: top=34 left=179.6527862548828 width=53.63888931274414 height=23.55555534362793
   - hotspots: 1
     - hotspot_01 (188.56379356751887, 67.43621721558371), rect: top=34 left=179.6527862548828 width=53.63888931274414 height=23.55555534362793
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Click on 'Insert' in the top menu to open the dropdown options.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8okhceh0097l40cevnfiiwa/cm8okujcb00060cjr8qn4h5hl.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8okhceh0097l40cevnfiiwa/cm8okhv0q000403huvs8i4zb6.png
4. step_04 [image] - Hover over Chart.
   - source type: IMAGE
   - description: Customize Chart
   - target: (368, 268), rect: top=264.6666564941406 left=218.5416717529297 width=267 height=20
   - hotspots: 1
     - hotspot_01 (368, 268), rect: top=264.6666564941406 left=218.5416717529297 width=267 height=20
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Hover over the 'Chart' option in the dropdown menu. This displays different chart types.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8okhceh0097l40cevnfiiwa/cm8okujcs00070cjr05zn2yve.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8okhceh0097l40cevnfiiwa/cm8okhw7w000503hufrpvvmyy.png
5. step_05 [image] - Here we have our Chart for given data.
   - source type: IMAGE
   - description: Insert Chart into Sheet
   - target: (1169, 587), rect: top=165.7777862548828 left=46 width=1640 height=604
   - hotspots: 1
     - hotspot_01 (1169, 587), rect: top=165.7777862548828 left=46 width=1640 height=604
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Select the type of chart you want, and it will be created based on the data you selected.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8okhceh0097l40cevnfiiwa/cm8okujd700080cjrg9j4dy3y.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8okhceh0097l40cevnfiiwa/cm8oki0b3000603huz9ofu86o.png
7. [Outro] Save and Share Your Chart
   - body: Once your chart is created and customized to your preference, you can save your Google Sheet and share it with others to collaborate or present your data.
   - voiceover: You've successfully created a chart! You can now customize it further by using the Chart Editor that appears beside your newly created chart. Add titles, adjust colors, or change chart types as needed.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8okhceh0097l40cevnfiiwa/cm8okug9h00030cjrbbuf9eez.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM

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