Gadget list

Gadgets have been deprecated. See our for details.

Google Spreadsheets allows you to insert gadgets to display data in a variety of ways. The following is a list of gadgets created by Google, though you can use a variety of additional as well.

Area Chart

You can create an Area Chart gadget to display amounts over time. Here's how:

  1. Enter the data amounts for the chart in a few columns in your spreadsheet.
  2. Highlight the cells where you entered data in step 1.
  3. Go to Insert > Gadget.
  4. In the Add a Gadget window, scroll to Area Chart and click the Add to your spreadsheet button.

    Area chart gadget

  5. The gadget menu appears in your spreadsheet. In the 'Range' field, enter the column names where you added data in step 1.
  6. In the 'Title' field, create a title for your map.
  7. Click Apply. The chart appears in your spreadsheet. The example below shows the market penetration for certain web browsers.

    area chart gadget example

If you change any of the data relevant to this chart in your spreadsheet, the chart will update automatically. You don't need to repeat the steps above to edit this chart.

See this in action

Get your own copy

Bar Chart

Follow these steps to create a Bar Chart gadget:

  1. Enter the data for the chart in a few columns in your spreadsheet. Each column of data will become a bar in the chart.
  2. Highlight the cells where you entered data in step 1.
  3. Go to Insert > Gadget.
  4. In the Add a Gadget window, scroll to Bar Chart and click the Add to your spreadsheet button.

  5. The gadget menu appears in your spreadsheet. In the 'Range' field, enter the column names where you added data in step 1.
  6. In the 'Title' field, create a title for your chart.
  7. Click Apply. The chart appears in your spreadsheet. To make your chart look like the example below, you'll need to select the 'stack' option.

If you change any of the data relevant to this chart in your spreadsheet, the chart will update automatically. You don't need to repeat the steps above to edit this chart.

See this in action

Get your own copy

Image Line Chart

To create an Image Line Chart, which uses the Google Chart API and creates lines without visible data points, follow these steps:

  1. Enter the data for the chart in a few columns in your spreadsheet: enter names in the first columns and values in the next columns.
  2. Highlight the cells where you entered data in step 1.
  3. Go to Insert > Gadget.
  4. In the Add a Gadget window, scroll to Image Line Chart and click the Add to your spreadsheet button.
  5. The gadget menu appears in your spreadsheet. In the 'Range' field, enter the column names where you added data in step 1.
  6. In the 'Title' field, create a title for your chart.
  7. If you're charting percentages, enter 1 in the 'Maximum value' field.
  8. Click Apply. The chart appears in your spreadsheet.

    Image line chart example

If you change any of the data relevant to this chart in your spreadsheet, the chart will update automatically. You don't need to repeat the steps above to edit this chart.

See this in action

Get your own copy

Line Chart

Follow the instructions below to insert a Line Chart gadget:

  1. Enter the data for the chart in a few columns in your spreadsheet: enter names in the first columns and values in the next columns.
  2. Highlight the cells where you entered data in step 1.
  3. Go to Insert > Gadget.
  4. In the Add a Gadget window, scroll to Line Chart and click the Add to your spreadsheet button.

    Line chart gadget

  5. The gadget menu appears in your spreadsheet. In the 'Range' field, enter the column names where you added data in step 1.
  6. In the 'Title' field, create a title for your chart.
  7. Click Apply. The chart appears in your spreadsheet.

    Line chart example

If you change any of the data relevant to this chart in your spreadsheet, the chart will update automatically. You don't need to repeat the steps above to edit this chart.

See this in action

Get your own copy

Organizational Chart

You can use the Organization Chart gadget to build organization charts in your spreadsheets. Just follow these steps:

  1. In your spreadsheet, enter the names you'd like to include in your organization chart: in the 1st column, enter the employee name(s) or other data. In the 2nd column, enter the manager's name or other data.
  2. Highlight the cells where you entered data in step 1.
  3. Go to Insert > Gadget.
  4. In the Add Gadget window, click the Organizational link.
  5. Click the Add to your spreadsheet button beneath Organization Chart.

    organization chart

  6. The gadget menu appears in your spreadsheet. Enter a 'Range' and a 'Title.' The Range includes the two columns you created in step 1.
  7. Click Apply. The gadget appears in your spreadsheet.

    In the example below, Malaika manages Christian, Lydie, Sophie and Lasse, while Regina manages everyone (including Malaika).

    organizational chart example

If you change any of the data relevant to this chart in your spreadsheet, the chart will update automatically. You don't need to repeat the steps above to edit this chart.

See this in action

Get your own copy

Pie Chart

Follow the instructions below to insert a Pie Chart gadget:

  1. Enter the data for the chart in two columns in your spreadsheet: enter names in the first column and numeric values in the next column.
  2. Highlight the cells where you entered data in step 1.
  3. Go to Insert > Gadget.
  4. In the Add a Gadget window, scroll to Pie Chart and click the Add to your spreadsheet button.

    Pie chart gadget

  5. The gadget menu appears in your spreadsheet. In the 'Range' field, enter the column names where you added data in step 1.
  6. In the 'Title' field, create a title for your chart.
  7. Click Apply. The chart appears in your spreadsheet.

    pie chart gadget example

If you change any of the data relevant to this chart in your spreadsheet, the chart will update automatically. You don't need to repeat the steps above to edit this chart.

See this in action

Get your own copy

Scatter Chart

Follow the instructions below to insert a Scatter Chart gadget:

  1. Enter the data you want to chart in adjacent columns in your spreadsheet (see the image below step 7).
  2. Highlight the cells where you entered data in step 1.
  3. Go to Insert > Gadget.
  4. In the Add a Gadget window, scroll to Scatter Chart and click the Add to your spreadsheet button.

    Scatter chart gadget

  5. The gadget menu appears in your spreadsheet. In the 'Range' field, enter the column names where you added data in step 1.
  6. In the 'Title' field, create a title for your chart.
  7. Click Apply. The chart appears in your spreadsheet.

    scatter chart example

If you change any of the data relevant to this chart in your spreadsheet, the chart will update automatically. You don't need to repeat the steps above to edit the chart.

See this in action

Get your own copy

Gauges

You can use the Gauges gadget to set up a numeric gauge in your spreadsheet. To do so, you'll need to enter a number in a cell and then a range of numbers in the gadget window. Just follow these steps:

  1. Enter a number in a cell of your spreadsheet.
  2. Go to Insert > Gadget.
  3. In the Add a Gadget window, scroll to Gauges and click the Add to your spreadsheet button.

    Gauges gadget

    The gadget's set-up window appears in your spreadsheet.

  4. In the 'Range' field, enter the cell name where you added a number in step 1.
  5. In the 'Title' field, enter a title for the gadget.

    Gauge Gadget in a spreadsheet

  6. Click Apply. The Gauge gadget appears in your spreadsheet.

See this in action

Get your own copy

Heatmap

The Heatmap gadget displays a map with color intensities based on values you add to your spreadsheet, including country ISO (International Organization for Standardization) codes and data you want to show.

To enter a Heatmap gadget, follow these steps:

  1. In one column of your spreadsheet, enter the relevant country ISO codes (you can see a full list at the ISOwebsite).
  2. In the adjacent column(s), enter the data you want to show.
  3. Highlight the cells where you entered data in steps 1 and 2.
  4. Go to Insert > Gadget.
  5. In the Add a Gadget window, scroll to Heatmap and click the Add to your spreadsheet button.

    Heatmap gadget

  6. The gadget menu appears in your spreadsheet. In the 'Range' field, enter the column names where you added data in step 1.
  7. In the 'Title' field, create a title for the gadget.
  8. Click Apply. The gadget appears in your spreadsheet.

    Heatmap gadget example

If you change any of the data relevant to this chart in your spreadsheet, the chart will update automatically. You don't need to repeat the steps above to edit this chart.

See this in action

Get your own copy

Image Search

You can use the Image Search Gadget to include popular images in your spreadsheets. Just follow these steps:

  1. In a cell of your spreadsheet, enter a search keyword for your Image Search.
  2. Go to Insert > Gadget.
  3. In the Add Gadget window, click the Add to your spreadsheet button beneath Image Search.

    Add Image Search Gadget button

  4. Once the gadget appears in your speadsheet, you'll need to enter a Range and a Title. The Range refers to the cell that contains the image search keyword. For example, if you added "Google" to cell L1 in step 1 above, an image search on the word "Google" is performed.

    Gadget window

  5. Click Apply. The gadget displays the top two images of the image search.

See this in action

Get your own copy

Interactive Time Series

You can create an Interactive Time Series, just like the ones in Google Finance. To do this, you'll need to add dates in the first column and numeric values in the following columns. Here's an example:

Interactive time series chart

Map

Use the Map Gadget to add interactive maps to your spreadsheets. Just follow these steps:

  1. In a column of your spreadsheet, enter the addresses you want to map. If you want display a tooltip when you click a location in the map, add the tooltip text to an adjacent column.
  2. Highlight the cells where you entered data in step 1.
  3. Go to Insert > Gadget.
  4. In the Add a Gadget window, scroll to Map and click the Add to your spreadsheet button.

    Map gadget

  5. The gadget menu appears in your spreadsheet. In the 'Range' field, enter the column names where you added data in step 1.
  6. In the 'Title' field, create a title for your map.
  7. Click Apply. The map appears in your spreadsheet.

    Map Gadget example

If you change any of the data relevant to your map in your spreadsheet, the map will update automatically. You don't need to repeat the steps above to edit the map.

See this in action

Get your own copy

Motion Chart

If you're tracking several data points to see changes over time, you can create an interactive Motion Chart. Here's how:

  1. In several columns of a spreadsheet, add the data (including column headings) for your chart. You'll need to create columns for the main data point, the time period (Motion Chart supports day, month, quarter and year), and two additional numeric values. See the image below step 7 for an example.
  2. Highlight the cells where you entered data in step 1.
  3. Go to Insert > Gadget.
  4. In the Add a Gadget window, scroll to Motion Chart and click the Add to your spreadsheet button.

    Motion chart gadget

  5. The gadget menu appears in your spreadsheet. In the 'Range' field, enter the cell names where you added data in step 1.
  6. In the 'Title' field, create a title for your chart.
  7. Click Apply. The chart appears in your spreadsheet.

    Motion chart example

These are some of the Motion chart features available:

Zoom: Choose a data range (x and y) that will become the chart boundaries, then zoom in to focus on an area within the chart.

Bar charts: Switch between a bubble chart and a bar chart by clicking the icons at the top right of the chart window. You can organize the bars in alphabetical order or other order you select from the Order drop-down menu, below the chart.

Settings panel: Click the wrench icon to access this new panel. Use the slider to set the transparency of bubbles or bars that aren't currently selected. Click How to zoom to find instructions for zooming in and out.

Learn how to format your data.

Note: if you change any of the data relevant to this chart in your spreadsheet, the chart will update automatically. You don't need to repeat the steps above to edit the chart.

See this in action

Get your own copy

Table

The Table gadget lets you filter and group data according to categories that you create. To insert a Table gadget, follow the steps below.

  1. In several columns of a spreadsheet, add the data (including column headings) for your table. See the image below step 7 for an example.
  2. Highlight the cells where you entered data in step 1.
  3. Go to Insert > Gadget.
  4. In the Add a Gadget window, scroll to Table and click the Add to your spreadsheet button.

    Table gadget

  5. The gadget menu appears in your spreadsheet. In the 'Range' field, enter the cell names where you added data in step 1.
  6. In the 'Title' field, create a title for your table.
  7. Click Apply. The table appears in your spreadsheet.

    Table gadget example

If you change any of the data relevant to this table in your spreadsheet, the table will update automatically. You don't need to repeat the steps above to edit the table.

See this in action

Get your own copy

Web Search

The Web Search gadget allows you to search the Web and display results for specified values. Just follow these steps:

  1. Enter a few search terms in your spreadsheet.
  2. Highlight the cells where you entered data in step 1.
  3. Go to Insert > Gadget.
  4. In the Add a Gadget window, scroll to Web Search and click the Add to your spreadsheet button.

    Web Search gadget

  5. The gadget menu appears in your spreadsheet. In the 'Range' field, enter the cell names where you added data in step 1.
  6. In the 'Title' field, create a title for your chart.
  7. Click Apply. The chart appears in your spreadsheet.

    Web Search gadget example

See this in action

Get your own copy

Interested in creating a Gadget of your own? Check out the Google Gadgets API and the Google Visualization API. For help using these APIs check out the Google Visualization API forum and the Google Gadgets API forum.