Analyze data - Google Docs Editors Help (2024)

Switch from Excel to Sheets

Next: Use macros and add-ons

Excel: Insert charts	Sheets: Add a new chart
Excel 2013 Excel 2010	In a spreadsheet, highlight the range of data that you want to create a chart for. Click InsertChart. (Optional) To customize the chart, click MoreEdit chart. You can also add a Sheets chart to a Slides presentation. For details about adding charts, see Add and edit a chart orgraph.

In a spreadsheet, select a range of cells, columns, or rows. Otherwise, you’ll get insights based on where your cursor is.
At the bottom, click Explore .
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 customize a chart, click MoreEdit chartCustomize.

Add charts to Docs and Slides

Excel: Copy and paste	Sheets: Copy and paste
Excel 2013 and 2010	Help people visualize 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. In Sheets, open the spreadsheet and in the chart, click MoreCopy chart. In Docs or Slides, paste the chart. 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. Click Paste.

Excel:
Copy and paste

Sheets:
Copy and paste

Excel 2013 and 2010

Help people visualize 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.

In Sheets, open the spreadsheet and in the chart, click MoreCopy chart.
In Docs or Slides, paste the chart.
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.
Click Paste.

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 Visualization API Query Language query across data.
GOOGLEFINANCE	Gets current or historical securities information from Google Finance.
GOOGLETRANSLATE	Translates text from one language into 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.

Add pivot tables

Excel: Insert a pivot table	Sheets: Add a new pivot table
Excel 2013 and 2010	Highlight data in your spreadsheet. Click InsertPivot table. A pivot table opens in a new sheet (tab). In the Pivot table editor, add rows, columns, values, and filters. For details, see .

Excel:
Insert a pivot table

Sheets:
Add a new pivot table

Excel 2013 and 2010

Highlight data in your spreadsheet.
Click InsertPivot table. A pivot table opens in a new sheet (tab).
In the Pivot table editor, add rows, columns, values, and filters.

For details, see .

Get automatic pivot tables

Excel: Insert a pivot table	Sheets: Get automatic pivot tables
Excel 2013 and 2010	In your spreadsheet containing the source data, click Explore . Choose an option: Point to a pivot table and click Insert pivot table . Ask a question about your data under Answers. The resultscan include pivot tables. To add one, point to it and clickInsert pivot table . For details, see .

Excel:
Insert a pivot table

Sheets:
Get automatic pivot tables

Excel 2013 and 2010

In your spreadsheet containing the source data, click Explore .
Choose an option:
- Point to a pivot table and click Insert pivot table .
- Ask a question about your data under Answers. The resultscan include pivot tables. To add one, point to it and clickInsert pivot table .

For details, see .

Want advanced Google Workspace features for your business?

Try Google Workspace today!

_{Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companieswith which they are associated.}

Next: Use macros and add-ons

Need more help?

Try these next steps:

Post to the help community Get answers from community members

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.

Analyze data - Google Docs Editors Help (2024)

Switch from Excel to Sheets

On this page

Add charts

Excel:
Insert charts

Sheets:
Add a new chart