Skip to main content

Introduction

Learn how to create a chart in Google Sheet.

  1. Typing "google.com" in the address bar to go to the google website
    • Typing "google.com" in the address bar to go to the google website

  2. Click on the "Sign In" button to sign in your google account
    • Click on the "Sign In" button to sign in your google account

  3. Type your email address into this box
    • Type your email address into this box

    • Click on the blue "Next" button

  4. Type your password into this box
    • Type your password into this box

    • Click on the blue "Sign In" button

  5. Click this button to open a menu of options
    • Click this button to open a menu of options

    • Click on the "Sheet" button

  6. Click + button to create new spreadsheet
    • Click + button to create new spreadsheet

  7. Creating a Bar chart (also called as Column chart).
    • Creating a Bar chart (also called as Column chart).

  8. Click a box, and then type information you want to use.
    • Click a box, and then type information you want to use.

    • You should put the name of the variable on the very left column and very top row.

  9. Select the table by click and drag the cursor.
    • Select the table by click and drag the cursor.

    • Click "Insert"

    • Click "Chart..."

  10. Click the box on the very left side ("Switch rows/columns") if you want to change.
    • Click the box on the very left side ("Switch rows/columns") if you want to change.

  11. Click "Charts"
    • Click "Charts"

    • Click "Column"

    • Click this chart if you want to make the chart horizontally.

  12. Click "Customise"
    • Click "Customise"

    • You can edit the Title here.

    • You can edit the Legend here.

    • If you scroll down, you can edit the 'Axis', 'Series'.

    • Click "Insert" then you can insert the chart in your spreadsheet.

  13. Creating a Basic Line Chart
    • Creating a Basic Line Chart

  14. Click a box, and then type information you want to use.
    • Click a box, and then type information you want to use.

  15. Select the table by click and drag the cursor.
    • Select the table by click and drag the cursor.

    • Click "Insert"

    • Click "Chart..."

  16. Click the box on the very left side ("Switch rows/columns") if you want to change.
    • Click the box on the very left side ("Switch rows/columns") if you want to change.

  17. Click "Charts"
    • Click "Charts"

    • Click "Line"

    • Click this chart if you want to make basic line chart.

  18. Click "Customise"
    • Click "Customise"

    • You can edit the Title here.

    • You can edit the Legend here.

    • If you scroll down, you can edit the 'Axis', 'Series'.

    • Click "Insert" then you can insert it in your spreadsheet.

  19. Creating a basic Pie Chart.
    • Creating a basic Pie Chart.

  20. Click a box, and then type information you want to use.
    • Click a box, and then type information you want to use.

  21. Select the table by click and drag the cursor.
    • Select the table by click and drag the cursor.

    • Click "Insert"

    • Click "Chart..."

  22. Click "Chart"
    • Click "Chart"

    • Click "Pie"

    • You can choose any type of pie here.

  23. Click "Customise"
    • Click "Customise"

    • You can edit the Title here.

    • You can edit the Legend here.

    • If you scroll down, you can edit the circle, and 'Series'.

    • Click "Insert" then you can insert the chart in your spreadsheet.

Finish Line

Mirai

Member since: 06/08/2015

1 Reputation

41 Guides authored

0 Comments

Add Comment

View Statistics:

Past 24 Hours: 0

Past 7 Days: 1

Past 30 Days: 1

All Time: 84