On this page
Add charts
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 Insert Chart.
- (Optional) To customize the chart, click More Edit 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 .
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 More Copy chart.
- In Docs or Slides , paste the chart.
- Choose an option:
- To update the chart if the source data changes, keep Link to spreadsheetselected. 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 Insert Pivot table. A pivot table opens in a new sheet (tab).
- In the Pivot table editor, add rows, columns, values, and filters.
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.