This wikiHow teaches you how to create a graph (or chart) from data in Google Sheets using the Google Sheets website.
Step
Step 1. Open Google Sheets
Visit https://sheets.google.com in a browser. If you're signed in to your Google account, you'll see the Google Sheets dashboard.
If you're not logged into your Google account, enter your email address and password when prompted before continuing
Step 2. Click Blank at the top left of the window to open a new sheet with no content
If you already have a spreadsheet containing data, click on it, then follow the steps in this article starting from step five
Step 3. Create the data header
Click cell A1, then enter the x-axis label. After that, click cell B1, then enter the y-axis label.
- For example, if you want to record the amount of coffee consumed in a day, write "Hour" in the cell A1, and "Amount of coffee" in cell B1.
- The placement of the labels on your spreadsheet may differ depending on the type of chart you are creating.
- You can add data headers in cells C1, D1, and so on, if your data is more than two sets.
Step 4. Enter the data
Fill in the column A with x-axis data, and column B with y-axis data.
If you have more than one column of header data, enter the information in each column
Step 5. Select your data
Click cell A1, then hold down Shift while clicking the bottom cell in the rightmost column of data. The data you select will be marked in blue.
Step 6. Click the Insert tab near the top left of the screen
You will see a drop-down menu.
Step 7. Click the Chart option in the middle of the menu Insert.
After clicking on the menu, a built-in chart will be created based on the data you selected. You will see a window on the right side of the page.
Step 8. Choose a chart format
Click the "Chart type" box at the top of the window, then click chart format in the box that appears. The chart in the middle of the page will appear according to your choice.
Step 9. Share the chart
Click File, then select Share on the drop-down menu. Enter a name, then click Save if requested. After that, enter the email address of the destination, and click Send.
