On this page
- Add charts
- Get automatic charts
- Add charts to Docs and Slides
- Functions in Sheets and Excel
- Add pivot tables
- Get automatic pivot tables
Add charts
Excel:
|
Sheets:
|
---|---|
Excel 2013
Excel 2010 |
You can also add a Sheets chart to a Slides presentation. For details about adding charts, see Add and edit a chart or graph.
|
Get automatic charts
Get summaries and charts of your data with the click of a button in Sheets. It’s kind of like having an expert in data analysis sitting next to you.
Sheets: Get automatic charts
- 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:
|
Sheets:
|
---|---|
Excel 2013 and 2010 |
Help people visualize data in a presentation or document by adding charts
|
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:
|
Sheets:
|
---|---|
Excel 2013 and 2010 |
For details, see Create & use pivot table. |
Get automatic pivot tables
Excel:
|
Sheets:
|
---|---|
Excel 2013 and 2010 |
For details, see Create & use pivot table. |
Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.