Inserting Gadgets

You can insert gadgets to display your spreadsheet data in a more visual way.

From your spreadsheet, simply select Insert > Gadget  . Then, the Add a Gadget window appears, where you can select gadgets in a number of categories, including charts, tables, and maps. Click Add to your spreadsheet  to insert a gadget. Below are two examples of Google gadgets you can add.

Motion chart

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

MotionChart

Instructions on how to insert this gadget

  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, and two additional numeric values.
  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.

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 .

Heatmap gadget

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. Here's an example:

MotionChart2

How to insert this gadget

  1. In one column of your spreadsheet, enter the relevant country ISO codes (you can see a full list at the   ISO   website).
  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.

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.

Check a list of Google gadgets| you can insert into your spreadsheet.

 

 

 
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

In: About Us