In case your data is in another source, such as Airtable, Shopify, WordPress, Xero, QuickBooks, and so on, pull them into Google Sheets first. Then, choose an option, Tap Done. Make a chart or GraphOn your Android phone or tablet, open a spreadsheet in the Google Sheets app, Select the cells you want to include in your chart, Tap Insert. We attempted to cover as many use cases as possible to show you the power of building graphs in Google Sheets.

To create a line graph, make sure to select “Line chart from the “Chart type dropdown after you have inserted a chart.

What is the easiest way to make a bar graph on Google Sheets?

Make sure that the first column of data you select contains the labels for the bars you want in your chart. Bar graphs and column graphs are very similar and are both great ways to show information in a digestible way. Google Sheets makes it quick and easy to generate bar graphs that update automatically when your data changes. Like the standard stacked bar graph, you can also make a 100% stacked bar chart; Google Sheets allows you to create a chart where all the bars are equal in size, and the value of each series in a bar shows as a percentage.

There’s a reason it’s important to understand your data before you learn how to make a bar chart in Google Sheets.

How do I make a grid graph in Google Sheets?

When creating a chart in Google Sheets, you may want to add gridlines to your chart so the users better understand the information contained in the chart.


Learn About Consolidata