Switch from Excel to Sheets

4. Analyse data in Sheets

In this section:

4.1 Add charts
4.2 Get automatic charts
4.3 Add charts to Docs and Slides
4.4 Functions in Sheets and Excel
4.5 Add pivot tables
4.6 Get automatic pivot tables

4.1 Add charts

Excel: 
Insert charts

Sheets: 
Add a new chart

Excel 2013
 

 

Excel 2010
  1. In a spreadsheet, highlight the range of data that you want to create a chart for.
  2. Click Insertand thenChart.
  3. (Optional) To customise the chart, click Moreand thenEdit chart.

You can also add a Sheets chart to a Slides presentation.

For details about adding charts, see Add and edit a chart or graph.

 

4.2 Get automatic charts

Get summaries and charts of your data with the click of a button in Sheets. It’s a bit like having an expert in data analysis sitting next to you. 

Sheets: Get automatic charts

  1. In a spreadsheet, select a range of cells, columns or rows. Otherwise, you’ll get insights based on where your cursor is.
  2. At the bottom, click Explore .
  3. Choose an option:
    • Point to a chart and click Insert chart .
    • Ask a question about your data under Answers.
      The results can include charts. To add one, point to it and click Insert chart .

Tip: To customise a chart, click Moreand thenEdit chartand thenCustomise.

4.3 Add charts to Docs and Slides

Excel:
Copy and paste

Sheets:
Copy and paste

Excel 2013 and 2010

Help people visualise data in a presentation or document by adding charts
from Sheets. If the source data changes, you can update the chart with the
click of a button.

  1. In Sheets, open the spreadsheet and, in the chart, click Moreand thenCopy chart.
  2. In Docs or Slides, paste the chart.
  3. Choose an option:
    • To update the chart if the source data changes, keep Link to spreadsheet selected. Then, if source data changes, at the top of the chart, click Update.
    • To keep the chart unlinked (not updated), select Paste unlinked.
  4. Click Paste.

4.4 Functions in Sheets and Excel

Most Excel functions are the same in Sheets. For a list of common functions, see the Sheets cheat sheet.

Some unique functions in Sheets:

FILTER Returns a filtered version of the source range, returning only rows or columns that meet specified conditions.
SORTN Returns a specified number of items in a data set after a sort.
SPARKLINE Creates a miniature chart in a single cell.
QUERY Runs a Google visualisation API query language query across data.
GOOGLEFINANCE Gets current or historical securities information from Google Finance.
GOOGLETRANSLATE Translates text from one language to another.
IMPORTRANGE Imports a range of cells from a specified spreadsheet.

For a list of all functions in Sheets, see the Google Sheets function list.

4.5 Add pivot tables

Excel:
Insert a pivot table

Sheets:
Add a new pivot table

Excel 2013 and 2010
  1. Highlight data in your spreadsheet.
  2. Click Dataand thenPivot table. A Pivot table opens in a new sheet (tab).
  3. In the Pivot table editor, add rows, columns, values and filters.

For details, see Create and use pivot table.

4.6 Get automatic pivot tables

Excel:
Insert a pivot table

Sheets:
Get automatic pivot tables

Excel 2013 and 2010
  1. In your spreadsheet containing the source data, click Explore .
  2. Choose an option:
    • Point to a Pivot table and click Insert Pivot table .
    • Ask a question about your data under Answers. The results can include Pivot tables. To add one, point to it and click Insert Pivot table .

For details, see Create and use pivot table.

Need more help?

Try these next steps:

Post to the Help Community Get answers from community members
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Main menu
1573352905616696506
true
Search Help Centre
true
true
true
true
true
35
false
false
false
false