How to Insert Other Gadgets in Excel Sheet in Google Docs

Google spreadsheet allows you to insert gadgets to your spreadsheet in order to exhibit the data in different ways. You can use a variety of gadgets that Google Docs allows along with some additional third party gadgets available as well. These gadgets can be used to best express the data.

Follow this step by step Google Docs tutorial to learn How to insert other gadgets in Excel sheet in Google docs.


Step # 1 – Click on the insert tab

First of all, open the document in which you want to insert a gadget. In this tutorial, we will be using a spreadsheet for the purpose. When the spreadsheet has opened, click on the “insert” tab which is in the menu bar. Once done, select the “Gadget” option from the drop down menu.

Go to the insert tab

Step # 2 – Select a gadget

Once you have clicked on the gadget button, a gadget box will appear on your screen. The box will be named as “Add a gadget”. In this box, you can access charts, tables, maps, web, diagrams, finance and custom tabs. By default you will be in the “Featured” tab and you can add gadgets from here. In this tutorial, we have added the “bars of stuff” gadget. Click on the “Add to spreadsheet” button to open up the gadget settings.

Choose a gadget

Step # 3 – Change gadget settings

In the “Gadget settings” box, you can manually select the range, give the gadget a title, choose the type of bars, etc. Once you are done, click on the “Apply and close button” to add the gadget to your spreadsheet.

Edit gadget settings

Step # 4 – Delete the Gadget

Once the gadget has been added, you can position the gadget to where ever you want. In order to delete a gadget, click on the gadget and then click on the “Gadget” button which will reveal a drop down menu. From the drop down menu, select the “Delete Gadget” option.

Remove the gadget