How to Insert Chart in Google Sheets

Author: Iqbal | Guide: Google Sheets |

Just like other figures and drawings, you can also insert charts in Google sheets.

Not just one, but you can add different types of charts and graphical representative figures in your Google sheets. They add a distinct element to your Google sheets. For example, you can insert pie charts in Google sheets as well as line graphs and column charts. These 6 easy steps will teach you how to insert a chart in Google sheets.

 

Insert Chart in Google Sheets in 6 Steps

Step-1 Get Started With Your Google Sheet: To get started with this technique, you first have to go to the Google sheet in which you want to add the chart.

You can either open the Google sheet in your web browser or you can also download the free mobile application. Do whatever suits you.

image Title insert chart in google sheet step 1

Step-2 Select Your Data: Obviously, you want to represent your data with the help of the chart. So, the following are the next steps:

  • Normally enter your data in the cells of your sheet.
  • Then, select the data with the help of your mouse and highlight it.
image Title insert chart in google sheet step 2

Step-3 Click As Shown: Now, you have to click on the 'Chart' option with the icon as you can see in the picture below.

This icon is present on the top right side of your spreadsheet.

image Title insert chart in google sheet step 3

Step-4 Change Your Chart Style From Here: A default chart will now be added to your Google sheet. If you are okay with the chart then you can leave it as it is.

But, if you want to change the style of the chart then, do the following:

  • Go to the 'Chart editor' on the right panel.
  • Click on the section where it is written 'Column chart'.
  • Then, select the chart style that you want.
image Title insert chart in google sheet step 4

Step-5 Click On 'X': After selecting and finalizing the chart style that you want to add in your Google sheet, click on the 'X' option as shown below.

image Title insert chart in google sheet step 5

Step-6 Chart is Now Added to Your Sheet: The Google chart of your choice is now added to your sheet.

It is now your turn to show your creativity. You have the option to customize the chart with the help of features that you can explore yourself.

image Title insert chart in google sheet step 6

FAQ

How Do I Make a Table Chart in Google Sheets?

To make a table chart in Google sheets, you have to make sure to follow the given steps in the correct sequence:

  • Open your sheet.
  • Go to the 'Insert' in the menu of tabs
  • Then, from here choose the option that says 'Chart'.
  • It will now insert a default chart type for you and open the Chart Editor sidebar at the same time.
  • Then, you have to go to the sidebar.
  • Now, tap on the 'Chart Type' in the drop-down box.
  • Scroll to the bottom below the other category and pick the 'Table Chart'.

Tabel chart will now be added!

How Can I Add a Chart to a Sheet in Google Docs?

This is a very typical process. But we have simplified this process of adding a chart to a sheet in Google Docs with the help of the given steps:

  • On your system, you have to start by opening a document in Google Docs.
  • Then, go to the top and click on 'Insert Chart From Sheets'.
  • You then have to select the spreadsheet with the chart you want to add.
  • Then, tap the 'Select' option.
  • Choose the chart that you want to add.
  • And, if you don't want the chart linked to the spreadsheet, uncheck 'Link to spreadsheet'.
  • Finally, click on the 'Import' button.

Does Google Sheets Also Have Tables like Microsoft Excel?

Both the Google sheets application and the Microsoft Excel program have similar functionality.

Google sheets as well as Microsoft Excel work with spreadsheets. But, Excel is more table-oriented whereas Google sheets are more sheet-oriented.

They have slightly different interfaces and formats. But you can also customize your Google sheet to make it look like an excel file by adding stripes. You can also create a border in your Google sheet.

How To Make a Table Chart In Microsoft Excel?

Simply follow the given steps to make a table chart in Microsoft Excel:

  • Open an Excel file in your system.
  • Then, enter and select the data for which you want to create a chart.
  • Click on the INSERT tab.
  • Then, choose the 'Recommended Charts' option.
  • In the Recommended Charts option, scroll through the list of charts that Excel recommends for your data.
  • You can click any chart to see how your data will look.
  • After choosing the chart, click on OK.

How Can I Edit a Chart in Google Sheets?

Google sheets provides its users with tons of options to customise an edit their charts. Let's look how it works:

  • Open your system and go to the Google sheet in which you want to edit the chart.
  • Then, double-click on the chart that you have already added and you want to change.
  • On the right side, click on 'Customize'.
  • Tap on 'Chart style'.
  • Make the changes you want and then click on 'SAVE'.

 

 

 

 

Another Method 

You might wish to construct a representation of your data once you've entered it into Google Sheets to make it easier to communicate. Fortunately, Google Sheets makes it simple to turn data into a graph or chart. If you want to depict components that make up a whole, a pie chart is a good alternative, but if you want to compare data, a bar graph is probably the best option. Here are our step-by-step instructions on How to Insert a Chart in Google Sheets.

Insert Chart in Google Sheets: 4 Steps

Step 1 - Open the google sheets app: Google Sheets are simple to use and provide intuitive tools that even non-technical users can use. To use Google Sheets to insert a chart, you must first have Google Sheets installed.

So, on your mobile device, open the Google Sheets program. Its icon resembles a green A4 sheet of paper. It is also divided into four identical cells by a white highlighted square.

  • If you can't find it, you need to download it and install it.
  • Go to the Google Play Store app and search for "Google Sheets" in the search field.
  • Look for the Google Sheets symbol and then tap on it to install it.
  • Allow it to finish downloading before continuing.

image titled Insert Chart in Google Sheets steps 1

Step 2 - Tap on cell Now we move onto the next step of our tutorial, and you'll need to tap on the cell on which you want to add the chart to in Google Sheets.

Google Sheets provides the opportunity to create and analyze data, and it is a very versatile tool that can do everything. Moreover, you can share your work with others, and they will see the formula and the result in real-time.

image titled Insert Chart in Google Sheets steps 2

Step 3 - Tap on the + icon present on the top corner: After you select the cell you want to add the link to, just tap on the + symbol that appears on the top corner of the interface. You may also tap on the "Insert" option depending on the version of google sheets you are using.

image titled Insert Chart in Google Sheets steps 3

Step 4 - Click on chart: Click on the "Chart" option in the drop-down menu. This will help create make types of graphs and charts, like line graphs, column charts, pie charts, etc in the sheets.

  • Charts make it easy to visualize the data and properly analyze it.
  • Instead of going through a whole lot of numbers you can just observe the chart and make a fare judgment.

image titled Insert Chart in Google Sheets steps 4

Conclusion

Google Sheets has a built-in function to insert charts. It's a very straightforward process and should not be too difficult to learn how to insert these charts into your own worksheets.

Make sure that the appropriate data is selected in your spreadsheet before inserting your chart. If you are trying to embed a chart from an online source; make sure to embed it correctly so that it doesn't break when inserted into your sheet.

Was this article helpful ?

No