Analyze data

Modified on Mon, 22 Sep at 1:03 PM

On this page

Add charts
Add charts to Docs and Slides
Functions in Sheets and Excel
Add pivot tables

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 InsertChart.
(Optional) To customize the chart, click MoreEdit chart.

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.

Functions in Sheets and Excel

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.

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.