How to create a graph in google sheets

Charts and Graphs are a useful tool used for conveying information to clients. Complex numerical data are often presented in the graphical form so that they can be easily understood and remembered. The Graphical representation of data helps to present the information and its developing trends over a period of time in a quick way.

Visual images like charts and graphs also help to highlight the important facts which can be easily remembered and understood. Charts are most often used in business and for daily assignments allowing you to easily see trends and comparisons in a visually appealing way. Whether you want to deliver a presentation to frame a report, charts take an important role in visualizing a complex data analysis to your audience.

Nowadays, Google Sheets is considered a viable alternative to Excel for its online accessibility from any device. Like Excel, Google Sheets includes various features to automate tasks and increase productivity. This web-based application lets you generate charts like any other spreadsheet to convey facts to the audience. It features a wide range of graphs and charts which you can choose for free to convey data in a visually appealing way.

In this article, we explain how to automatically generate charts in Google Sheets.

Generate Charts in Google Sheets

Launch Google Sheets and create a new spreadsheet or open an existing sheet.

Fill the sheets with data into the cells and organize the numerical facts with a column header.

Navigate to Insert and select the option Chart from the drop-down menu. A chart editor window pops up.

Click the option Setup in the chart editor window.

In the Chart type field, select the type of chart you want to create from the drop-down menu. Google Sheets provides 30 variety of charts that you can choose to create for your data.

In the Data range field, select the range of cells that you want to be displayed on the table. You can either choose to manually enter the range or use the pointer to select the data range.

Once the data range is entered, click OK.

Google Sheet will now create and display a chart with all the data selected from the range of cells in the sheet.

Now if you make any changes to the data in the sheets, the chart will be automatically updated with the new results without having to create a new chart for the updated value.

You can also change the type of chart for the same data easily in Google Sheets.

To change the chart type, double click on the chart. This will open a Chart Editor menu.

Go to Setup and in the Chart type field select a new type from the drop-down menu.

Click OK, and the Google Sheet will transform the chart into a new chart style for your data.

Customize charts in Google Sheets

Additionally, Google Sheets allow you to fully customize your charts based on the data. The customizing options allow you to configure the chart series, style, background color, axis labels, legend, and more.

To customize the chart, double click on the chart and select the Customize tab in the chart editor window.

The window displays options like Chart style, axis titles, series, axis labels, gridlines, and many more which you can choose based on the type of chart you want to create.

Click on any options which you want to configure and apply the changes.

All the adjustments you make in data and charts editor are automatically updated without having to repeat the entire process. The changes are reflected without you having to even refresh the page.

How to create a graph in google sheets

Do you need a quick organization chart to show the hierarchy of employees in your business? Well, just open a blank Google Spreadsheet, put the employee names in a column and your org charge should be ready in minutes. Here’s a sample org chart created with nothing but Google Sheets.

How to create a graph in google sheets

Create Organizational Charts with Google Spreadsheets

Here’s how you can put together an org chart in Google Sheets. It will be a live chart meaning as you update the employee names or hierarchy in the spreadsheet, the org chart would update itself. Let’s get started.

Step 1. Open a Google Sheet and put the employee names in column A and the names of the immediate managers in Column B.

Step 2. Select the cells that you’ve just entered and choose Chart from the Insert menu in the spreadsheet.

Step 3. The Chart Editor will open inside Google Sheets. Switch to the Chart Types tab and uncheck the option that says “Aggregate Column A.” Then scroll down the list of available chart types, choose “Organizational Chart” and click Insert to add the chart into your spreadsheet.

How to create a graph in google sheets

Unlike flowcharting tools like Visio, you don’t have enough formatting options for org charts in Google Sheets except for changing the background and fill colors of various nodes in the chart. And if you hit the little drop-down arrow in the chart box, you’ll see an option to download the charge as a PNG image for embedding on other websites.

By: Software Advice and Shubham Gupta on December 28, 2021

One of the most popular Google Drive applications is Google Sheets, which is a free online spreadsheet editor that allows users to chart their data and customize cells to create mathematical formulas.

Google Sheets has an additional option to embed various styles of custom graphs (which are referred to as “charts”). This allows users to create visual representations of their data.

In this article, you will learn the following:

How to enter graph data in Google Sheets

Before creating a graph, you must do the following:

1. Create a new Google Sheet

2. Enter the data you will use in your graph

How to create a new Google Sheet

To create a Google Sheet, complete these steps:

1. Open Google Drive. (From your Gmail account, click the nine dots icon and select “Drive.” Or, go to drive.google.com and sign in.)

How to create a graph in google sheets
To open Google Drive, from your Gmail account, click the nine dots icon and select “Drive.” Note: All source images from a personal Gmail account.

2. From the left hand menu, click “New.”

How to create a graph in google sheets
From the left hand menu, click “New.”

3. In the box that appears, select “Google Sheets.” A new Google Sheets document will appear in the next tab.

How to create a graph in google sheets
In the box that appears, select “Google Sheets.” A new Google Sheets document will appear in the next tab.

How to create a graph in google sheets
A new Google Sheets document will appear in the next tab.

How to enter data for a Google Sheet graph

To enter data for a Google Sheet graph, complete the following steps:

1. In the first column, enter the information you would like on the Y-axis. (This is the vertical axis of the graph.)

How to create a graph in google sheets
In the first column, enter the information you would like on the Y-axis. (This is the vertical axis of the graph.)

2. In the second column, enter the information you would like on the X-axis. (This is the horizontal axis of the graph.)

How to create a graph in google sheets
In the second column, enter the information you would like on the X-axis. (This is the horizontal axis of the graph.)

Or, you can also add a title to your graph. To do so, type the title in the top of the right-most column before creating your graph.

How to generate a Google Sheets graph

Now that you have entered the data you wish to use, you are ready to convert this data into a graph. To generate a graph in Google Sheets, complete the following steps:

1. Select the data you wish to use in your graph.

How to create a graph in google sheets
Select this data you wish to use in your graph.

2. From the document menu, select “Insert.”

3. In the box that appears, select “Chart.”

How to create a graph in google sheets
From the document menu, select “Insert,” then select “Chart.”

4. A new “chart” (that looks like a plain white box) will appear in the Google Sheet. A box titled “Chart editor” will also appear next to this box.

This plain box will become your graph after you customize its look and contents using the Chart editor. (You will learn about this in the next section.)

How to customize your Google Sheets graph

The “Chart editor” box has two tabs: Setup and Customize. You just learned how to set up your chart (and change this chart to any style, including a graph).

If you wish to change the chart style or the cells that comprise your chart (or if you wish to add more chart data) you can do so from the Setup tab. For all other edits, select the “Customize tab.”

How to create a graph in google sheets
The “Chart editor” box has two tabs: Setup and Customize. You can make all major edits from either of these tabs.

Customizing your graph

The Customize tab will allow you to change the following:

  • Chart Style (colors, borders, and font)
  • Chart and axis titles (including their fonts and sizes)
  • Horizontal and vertical axis colors and fonts

It will also allow you to add or remove the following:

  • A series (more graph lines with different data)
  • A legend
  • Gridlines

Each of these can be edited by clicking on the corresponding word(s). The box with these words will expand to display more options.

How to create a graph in google sheets
The options under “Customize.”

How to change the location and size of your graph

When you create a new graph, it will appear directly in your Google Sheet. You can easily change the location and the size of this graph once it was generated.

How to move a graph in Google Sheets

To move your new graph, complete the following steps:

1. Click anywhere on the graph

2. Hold down the mouse or touchpad to drag the box around your graph

How to resize a graph in Google Sheets

You can determine how large or small your graph should be. To resize your new graph, complete the following steps:

1. Click on the graph once

2. Click on any of the blue boxes that appear on the outline of the graph

3. Move the corner boxes diagonally to make your graph smaller or larger

4. Move the middle boxes to make your graph wider or longer

How to create a graph in google sheets
Move the blue boxes that outline the graph to resize the graph.

Use data visualization software to interpret data

Google Sheets makes it easy to visualize data in spreadsheets. If your organization requires a more enhanced version of this form of analytics, consider tools such as data visualization software. This software generates easy-to-interpret data, which allows small and mid-size businesses to make data-driven decisions about their operations and marketing campaigns.

Ben Stockton is a freelance tech writer from the United Kingdom. In a past life, he was a UK college lecturer, training teens and adults. Since leaving the classroom, he’s been a tech writer, writing how-to articles and tutorials for MakeUseOf, MakeTechEasier, and Cloudwards.net. He has a degree in History and a postgraduate qualification in Computing. Read more.

How to create a graph in google sheets

A data-heavy spreadsheet can be difficult to read through and process. If you’re using Google Sheets, adding graphs to your spreadsheet can help you present this information differently for easier reading. Here’s how you can add graphs to your spreadsheet.

Before we begin, you should be aware of a slight difference in terminology. Like Microsoft Excel, Google Sheets refers to all types of graphs as charts. You can use the Chart Editor tool to create these graphs and charts in Google Sheets.

Insert a Chart into Google Sheets

You can create several different types of graphs and charts in Google Sheets, from the most basic line and bar charts for Google Sheets beginners to use, to more complex candlestick and radar charts for more advanced work.

To start, open your Google Sheets spreadsheet and select the data you want to use to create your chart. Click Insert > Chart to create your chart and open the Chart Editor tool.

How to create a graph in google sheets

By default, a basic line chart is created using your data, with the Chart Editor tool opening on the right to allow you to customize it further.

How to create a graph in google sheets

Change Chart Type Using the Chart Editor Tool

You can use the Chart Editor tool if you want to change your chart type. If this doesn’t appear on the right automatically, double-click your chart to display the menu.

In the “Setup” tab, choose an alternative form of graph or chart from the “Chart Type” drop-down menu.

Different types of charts and graphs are grouped together. Click on one of the options to change your chart type from a line chart to something else.

How to create a graph in google sheets

Once selected, your chart will immediately change to match this new chart type.

Add Chart and Axis Titles

Newly created charts will attempt to pull titles from the data range you’ve selected. You can edit this after the chart is created, as well as add additional axis titles to make your chart easier to understand.

In the Chart Editor tool, click the “Customize” tab and then click “Chart & Axis Titles” to display the submenu.

How to create a graph in google sheets

Customize Chart Titles

Google Sheets will generate a title using the column headers from the data range you used for your chart. The “Chart & Axis Titles” submenu will default to editing your chart title first, but if it hasn’t, select it from the provided drop-down menu.

Edit the chart title to your chosen alternative in the “Title Text” box.

How to create a graph in google sheets

Your chart title will automatically change once you’ve finished typing. You can also edit the font, size, and formatting of your text using the options immediately below the “Title Text” box.

Adding Axis Titles

Google Sheets doesn’t, by default, add titles to your individual chart axes. If you want to add titles for clarity, you can do that from the “Chart & Axis Titles” submenu.

Click the drop-down menu and select “Horizontal Axis Title” to add a title to the bottom axis or “Vertical Axis Title” to add a title to the axis on the left or right of your chart, depending on your chart type.

How to create a graph in google sheets

In the “Title Text” box, type a suitable title for that axis. The axis title will automatically appear on your chart once you finish typing.

How to create a graph in google sheets

As with your chart title, you can customize the font and formatting options for your axis title using the provided options immediately below the “Title Text” box.

Change Chart Colors, Fonts, and Style

The “Customize” tab within the Chart Editor tool offers additional formatting options for your chart or graph. You can customize the colors, fonts, and overall style of your chart by clicking on the “Chart Style” submenu.

How to create a graph in google sheets

From here, you can choose different chart border colors, fonts, and background colors from the drop-down menus provided. These options will vary slightly, depending on the type of chart you’ve selected.

To save time, you can also set Google Sheets to automatically generate charts using a data range that you can continuously edit or add to. This will give you a graph or chart that automatically changes as you make edits to the data.

  • You can easily create a graph in Google Sheets to get a visual display of your data.
  • Once added, you can further customize the chart or graph so that it displays the information in the most comprehensible way.
  • Here’s how to use Google Sheets to create a graph to accompany your spreadsheet.
  • Visit Business Insider’s Tech Reference library for more stories.

Spreadsheets can be extremely useful tools in themselves, but at a certain point, all that data can just be too much to process.

That’s when a chart or graph can help clarify things. If you use Google Sheets, you can easily add a chart to your existing spreadsheet in just a few simple steps.

Here’s what you need to know to get it done.

How to create a graph in Google Sheets

Creating a graph in Google Sheets is fairly simple as long as you’re logged into your Google account.

1. Open your Google Sheet, or create a new one by going to sheets.new and inputting your data into a sheet.

2. Select the cells you want to use in your chart by clicking the first cell and holding shift on your Mac or PC keyboard while selecting the other cells you want to include.

3. In the top toolbar, select “Insert” and then “Chart.”

4. Your chart or graph will then appear over your spreadsheet. Google Sheets will select whichever chart it deems as the best option for your data. However, you can always change the kind of chart or graph used by clicking the drop-down menu in the chart editor, located on the right-hand side of the screen.

How to create a graph in google sheets

Charts and graphs are so helpful because they turn abstract numbers into something that can be understood at a glance. Google Sheets makes it easy to create charts or graphs out of numbers in your spreadsheet.

Begin by highlighting the data you want to include. (Don’t worry if you’re including data you don’t actually want to use: You can remove columns later.) In the example below, we’re working with US population data and want to visualize this.

Next, click Insert > Chart.

This will create a chart for you, though it might not the kind of chart you were hoping for.

You will also notice a new side panel on the right. This is the Chart editor, and it will show up any time a chart you’ve created is selected. The Chart editor has two main tabs: Setup, where you choose the type of chart you’re making and which data to include, and Customize, where you can change the chart’s appearance.

Making Different Kinds of Charts

Google Sheets can create 18 different kinds of charts using your data. You can choose which type you want by clicking the Chart Type dropdown in the right panel.

You could create a pie chart, for example. Here’s a quick breakdown of US population by state:

You can create a bar chart. Here’s US population by state, with data from both 2010 and 2018:

You can even create maps. Here’s net migration between 2010 and 2018:

There are 18 types of charts and graphs you can make in total, allowing you to visualize data in all kinds of useful ways. Find the one that works best for your data. Google offers an overview of every chart type.

Customizing Your Chart

Sometimes the chart will require some adjustment, of course. In my earlier example, showing the population of major US states at two points in time, the two bars were stacked. Like this:

Obviously, the population at two points in time is not cumulative. We need to configure the chart. This is done in the Setup tab of the side Chart editor.

Which options are shown here depends on what kind of chart you are making. We want to disable Stacking which shows up right at the top.

Set that to None and you’ll see the data side by side.

There is no end of configuration options like this, and it’s all fairly different depending on the kind of chart you’re trying to make. I recommend making a few charts and experimenting to really get a handle on how configuration works.

Customize Your Chart’s Colors, Font, and Labels

The Customize panel of the Chart editor lets you configure the look. It’s here you can customize the background color, for example, and change the font by clicking on the item in question or navigating to it in the panel.

You can also change things like axis labels, the legend, and more.

Again, what’s here will vary a lot depending on the kind of chart you’re making, so I recommend building a few charts in order to learn your way around.

Get productivity tips delivered straight to your inbox

We’ll email you 1-3 times per week—and never share your information.

In this tutorial, you will learn how to put two sets of data on one graph in Google Sheets.

If you have two related data sets in Google Sheets, you may want to chart them on the same graph. This can be useful to compare and contrast the data sets and also saves space in your spreadsheet

While it may not be immediately obvious how to make such a grap, it’s quick and easy in Google Sheets. Just follow the steps below.

Prepping The Data

The first step is to make sure your data is formatted correctly for charting

Step 1

Start with column headers for the X-axis and two data sets. These will be used for graph labels. In the image below, temperature is the X-axis, and the sales numbers for the two teams are the two data sets

Step 2

Now add your data underneath the headers. If X values are the same for the two datasets, this step is straightforward. If you have different X values for the two data sets, you will have to enter all values for the first data set, followed by the values for the second dataset, separately.. Ie, start with all X and Y values for the first data set directly under the header, then include all X and Y values for the second dataset underneath that

How to create a graph in google sheets

Inserting the Graph

Once you have your data entered as described above, it’s time to graph it

Step 1

Select the entire range you just entered data in, including the headers, then open the Insert menu and choose Chart

How to create a graph in google sheets

Step 2

In the Chart Editor sidebar, under Chart Type, select the type of graph you want. For this example, we’ll use a smooth line chart to nicely demonstrate the difference between the two data sets

How to create a graph in google sheets

Step 3

Your chart displaying both data sets is ready

How to create a graph in google sheets

Summary

In this tutorial, I covered how to put two sets of data on one graph in Google Sheets. Want more? Check out all the Google Sheets Tutorials.

This graph will demonstrate how to create a percentage graph in Excel and Google Sheets.

Make a Percentage Graph in Excel

The goal of this tutorial is show how to make a percentage graph based on different datasets.

Start with Data

We’ll start with data below.

Creating a Stacked Bar Graph

  1. Highlight the data
  2. Click Insert
  3. Select Graphs
  4. Click Stacked Bar Graph

How to create a graph in google sheets

Add Items Total

Create a SUM Formula for each of the items to understand the total for each.

How to create a graph in google sheets

Find Percentages

Duplicate the table and create a percentage of total item for each using the formula below (Note: use $ to lock the column reference before copying + pasting the formula across the table). Each total percentage per item should equal 100%.

How to create a graph in google sheets

Add Data Labels on Graph

  1. Click on Graph
  2. Select the + Sign
  3. Check Data Labels

How to create a graph in google sheets

Change Labels to Percentage

Click on each individual data label and link it to the percentage in the table that was made.

How to create a graph in google sheets

Final Percentage Graph in Excel

The final graph shows how each of the items change percentage by quarter.

How to create a graph in google sheets

Make a Percentage Graph in Google Sheets

Copy the same data on Google Sheets

Creating a Graph

  1. Highlight table
  2. Select Insert
  3. Click Chart

How to create a graph in google sheets

If the X and Y Axis need to be swapped, check or uncheck Switch Rows/Columns

How to create a graph in google sheets

Change Chart Type

  1. Select Box under Chart Type
  2. Click Stacked Column Chart

How to create a graph in google sheets

Adding Data Labels

  1. Click on Customize
  2. Select Series

How to create a graph in google sheets

3. Check Data Labels

How to create a graph in google sheets

Double Click on each Data label and manually edit it to match the percentage (Can’t manually change this based on formula like you can in Excel)

Sometimes the data that you are creating in a spreadsheet is better understood if you can create a visual representation of that data. This is often best achieved by making a graph so, if you are working on a spreadsheet, you may find yourself wondering how to make a graph in Google Sheets.

Fortunately this is something that you can generate with just a few steps. Once the graph has been created you will have a number of different options for customizing the way your data is displayed. So continue below to find out how to make a graph in Google Sheets.

How to Make a Graph in Google Sheets

  1. Open your Sheets file.
  2. Select the data for the graph.
  3. Click Insert.
  4. Choose Chart.
  5. Adjust settings in the Chart Editor.

Our article continues below with additional information on creating a graph in Google Sheets, including pictures of these steps.

Tools You Will Need

  • Computer with Internet connection
  • Modern Web browser like Chrome, Firefox, or Edge
  • Google Account
  • Google Sheets file with data for graph

How to Create a Graph in Google Sheets (Guide with Pictures)

The steps in this article were performed in the desktop version of Google Chrome, but will also work in other modern Web browsers like Firefox and Microsoft Edge. This guide will assume that you already have a spreadsheet containing data that you want to put into a graph, but you can also create a new spreadsheet and add the data for the graph as well.

Step 1: Go to your Google Drive at https://drive.google.com. If you aren’t already signed into your Google Account you will be prompted to do so.

Step 2: Open the Google Sheets file containing the data you want to graph, or create a new spreadsheet file.

Step 3: Select the cells containing the data that you want to put on the graph.

Note that you will want to have a header row in row 1 that contains the names that you want to use for the x and y axis of the graph. In the image below that would be “Month” and “Number of Sales.”

How to create a graph in google sheets

Step 4: Click the Insert tab at the top of the window.

How to create a graph in google sheets

Step 5: Choose the Chart option.

How to create a graph in google sheets

Step 6: Find the Chart editor column at the right side of the window, where you will see a number of different options for customizing the appearance and layout of your graph.

There should also be a graph on the spreadsheet displaying your graphed data using the current settings in the Chart editor column.

How to create a graph in google sheets

Step 7: Adjust the settings in the Chart editor to get the graph appearance that you need for your work.

How to create a graph in google sheets

Google Sheets Chart Editor Options

The options in the Chart editor on the Data tab are:

  • Chart type – Select the type of graph for your data. There are a ton of options on this menu, so you can experiment with them until you find the one that works best for you.
  • Stacking – This option will let you display “stacked” data in your graph, but requires multiple columns and a specific format. You can read this article on Google’s support site for additional information on stacked charts.
  • Data range – This setting defines the range of cells in your spreadsheet that are comprising the data display for the graph. You can change this if you want to use a different range of cells.
  • X-axis – You can modify this to change the data that is being used to determine the x axis of the graph.
  • Series – You can modify this to change the data that is being used for the y axis of the graph.
  • Switch rows/columns – Turn your rows into columns and vice versa for the graph layout, which will affect the way that the graph data is displayed. This can be useful if you want to switch the x axis and y axis in Google Sheets.
  • Use row x as headers – Select this if your data contains headers that you want to use to label the axes of your graph.
  • Use column x as labels – Select this to use the data in the specified column as labels for your data.
  • Aggregate column x – This lets you aggregate the data in the specifiedcolumn. Note that this may not change anything depending on the type of data in that column.

There are additional options available if you click the Customize tab in the Chart Editor. These options include:

  • Chart style
  • Chart & axis titles
  • Series
  • Legend
  • Horizontal axis
  • Vertical axis
  • Gridlines

Additional Notes

  • If you update the data in the cells that are populating the graph, then the graph will update automatically.
  • While Google Sheets will save itself automatically when you make changes, this doesn’t happen if you lose your Internet connection. So make sure that you see a “Saved” note at the top of the page if you have done a lot of work that you don’t want to risk losing because you don’t have an Internet connection.
  • If you click back into the spreadsheet, the Chart editor column will disappear. You can reopen the Chart editor by clicking the three dots at the top-right of the graph, then choosing the Edit data option.

Would you rather work on your spreadsheet in Excel than Google Sheets? Find out how to export a Google Sheets file for Microsoft Excel by downloading a copy of the file in the .xlsx file format.

Additional Sources

Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.

After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.

His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.

Charts and graphs are very helpful when you are working with a lot of data. They turn abstract numbers into something that can be understood at a glance.

How to create a graph in google sheets

Oct 28, 2019 ● 5 min read

Table of Contents

  • Why Making a Bar Graph?
  • How to Make a Bar Graph in Google Sheets
  • How to Make a Line Graph in Google Sheets
  • How to Make a Graph on Google Docs

There are a lot of features that enable complex analysis, and presenting data in the form of charts or graphs is one of them. But, a lot of users want to know how to make a graph in Google Sheets?

In this article, you’ll learn how to make a bar graph in Google Sheets, how to customize it, its advantages, and get the idea for making other graphs or charts in Google Sheets.

Why Making a Bar Graph?

A lot of people make bar graphs or charts to visualize their data. The reason for that is because they are very easy to interpret and ideal means for communicating categorical ranking and comparison of different datasets.

How to Make a Bar Graph in Google Sheets

  • First, create a table, you can create the table in two different ways horizontal or vertical. Do not add the units (e.g. g, ml) with numbers or it will generate an error when you make the graph. You will select the unit later.
  • Now select the data or cells you want to create the table with and click insert chart button. If you cannot find the insert chart button on your menu, click insert at the second row on your menu and then select the chart from the drop-down menu.
How to create a graph in google sheets How to create a graph in google sheets

The chart and chart editor will appear, from there, you can select the type of graph you want to create, and customize your graph.

  • You can change the chart style, make it 3D if you prefer that look.
  • Change the graph title. You can also change the axes’ title, either horizontal axis title or vertical. You can change the legend, the minimum and maximum value, horizontal and vertical axis’ size.
  • If you prefer a grid in the background of your chart, add grid in the background.
How to create a graph in google sheets

How to Make a Line Graph in Google Sheets

Making a line graph in Google sheets is similar to making a graph on excel. Following are step by step instructions to create a line graph in Google sheets. Let’s say you want to create a graph on time vs distance.

  • Put all your data in time and distance columns.
  • Put the values you want in the x-axis in the left-most column, and the values you want to add in the y-axis in the right columns.
  • Select all the data, and click on the chart from the right side of the top menu. If you can’t find the chart icon, you can click insert and scroll down in the drop-down menu and click charts.
  • The different kind of charts window will appear, click on chart types in the middle. There you will see different types of graphs from a scatter graph to the bar graph. Click on the line graph type; you can see the preview on the right side.
  • Then you can click on the options you want to choose. For instance, if you want to select a column as a header and another column as a label.
How to create a graph in google sheets

After that, click on the next button named customization.

  • From there, first, you can write your graph title, change the size, font or color of the title.
  • Then select the legend’s position, you can put it at the right side, left or at the bottom.
  • Moreover, you can also change the background color if you want something other than white.
  • Next, you can edit the horizontal or vertical axis title.
  • You can change the appearance of the lines, make them slanted.
  • After that, you can select the minimum and maximum value.
  • Plus you can change the number of the background grid lines, and you can also select a minor grid line to represent the half in numbers.
  • Lastly, you can change your line thickness, line and point shape and size.
How to create a graph in google sheets

After you are satisfied with your graph, click insert graph at the bottom. Now you have your graph on sheet. You can change its size, click on the edit icon at the top-right side of the graph and edit the graph such as change the line color and thickness. You can also click on labels, or axis and edit, or change the minimum and maximum value. At last, click on the view only icon at the top of the edit icon.

How to Make a Graph on Google Docs

After you make your graph in Google sheets, you can see a drop-down icon on the top-right side of the graph. When you click the icon, a drop-down menu appears, select the copy graph option. Open your Google doc, and past the graph, the Google doc will give you two options, either paste the linked Google sheets graph or paste the unlinked graph.

How to create a graph in google sheets

The difference between linked and unlinked graph is when you edit your graph on Google sheet, the linked graph will show an update button at the top-right side of the graph. When you click the update, the graph will change in your Google doc with the changes you make on Google sheets. The unlinked graph does not have this option, and you can not change it automatically with the Google sheets graph.

Now that you have learned all the charting tools, you can convey your message clearly and avoid clutter in the chart. If you are too busy to create a graph, you can turn your spreadsheets into beautiful reports using Whatagraph’s Google Sheets Integration, an easy and quick way to create automated reports.

How to create a graph in google sheets

Create a chart in Google Sheets to call out specific data or provide a unique way to view it. You can easily customize the chart and its appearance.

Sometimes a spreadsheet can contain an enormous amount of data. So when it’s time to analyze that data or share the sheet with someone else, it can be overwhelming. However, a tool like a graph or chart not only displays your data in a unique form but also let you call out certain data for a clearer visual amidst the chaos.

Like Microsoft Excel, Google Sheets offers a handy feature for creating a chart easily. You can choose from several chart types and completely customize the chart for the ideal appearance.

Create a Chart in Google Sheets

If you have data that would fit perfectly into a chart, head to Google Sheets, sign in, and open your spreadsheet. Follow these steps to create the chart.

  1. Select the data for the chart. You can do this by dragging through the cells you want to use.
  2. Click Insert >Chart from the menu.
  3. You’ll immediately see your chart, using a suggested style. And the Chart Editor will open on the right. So you can click the Chart Type drop-down list and pick a different style like a line, area, bar, or pie chart.

How to create a graph in google sheets

Depending on the type of chart you use, the remaining Setup options in the Chart Editor will vary. For instance, if you choose a column, area, or waterfall chart, you can apply Stacking.

Data Range

For all chart types, you can see the Data Range. So if you need to make an adjustment or want to add another range, click the Select Data Range icon.

How to create a graph in google sheets

Axis and Aggregate

You can remove or add labels to the X- or Y-axis by clicking the Options (three dots) icon on the right of that item. If you’d like to Aggregate the data, check that box and then pick average, sum, count, or another option in the drop-down list.

How to create a graph in google sheets

Series

You have options to remove a series or add labels by clicking the three dots to the right of one. Or you can click Add Series at the bottom of the list for additional data.

How to create a graph in google sheets

Other Options

At the bottom of the Chart Editor, you also have the ability to switch rows and columns, use row 1 as chart headers, and use column A as labels. Just check the boxes next to the items you want to apply.

Move or Resize

  • To move your chart to a different spot on your sheet, simply grab it and drag where you want it.
  • To resize your chart, select it and drag from one of the corners or borders.

Customize Your Chart

Once you create your chart and organize the data as you like, you have ways to customize the chart. This lets you apply changes to the appearance like color, style, and gridlines.

If you’ve already closed the Chart Editor, you can reopen it easily. Click the three dots on the top right of the chart and select Edit Chart.

How to create a graph in google sheets

In the Chart Editor, click the Customize tab at the top. You’ll see several options for changing the appearance of your chart, each can be collapsed or expanded. These options vary depending on your chart type.

Chart Style: Change the background color, font, border, and overall look.

Chart & Axis Titles: Add text for the chart title, subtitle, horizontal, or vertical axis titles. Then, choose the font style, size, format, and color for those you use.

Series: Format the axis position and data point and select colors for items in the series.

How to create a graph in google sheets

Legend: Add, remove, and position the legend on the chart. You can also format the font.

Horizontal Axis and Vertical Axis: Adjust the font style, size, format, and color for the selected axis. You also have options to slant the labels on the horizontal axis and choose a scale factor for the vertical axis.

Gridlines and Ticks: Choose the spacing types and counts, add major and minor ticks, and pick the gridline color.

How to create a graph in google sheets

Again, the options in the Customize section of the Chart Editor depend on the chart you use. So if you pick a pie chart, for example, you can add a donut hole and select its size.

Time-Saving Tip: Not sure which section of the Chart Editor you need to access for a particular part of the chart? Make sure the Chart Editor is open and then click the item directly on the chart. This action will display the expanded corresponding area in the Chart Editor to make your edits.

How to create a graph in google sheets

Create a Chart in Google Sheets for Data Visualization

If you want to call attention to particular data or simply view your data in a visually pleasing way, create a chart in Google Sheets. You have complete flexibility with how your chart looks and the data it shows.

Need a little help with charts in Microsoft Excel? Take a look at our walk-through for creating a Gantt chart in Excel. Or check out how to create a pie chart in Excel 2010 if you are running an older version of Office.

Step-by-step tutorials on how you can create a chart with multiple ranges of data. We’ll also take you through how to flip rows and columns so chart input is easier!

Table of Contents
  1. Flip Columns and Rows onВ Google Sheets
  2. Create a Chart with Multiple Ranges of Data
Table of contents

How to create a graph in google sheets

How to create a graph in google sheets

How to create a graph in google sheets

  1. Flip Columns and Rows onВ Google Sheets
  2. Create a Chart with Multiple Ranges of Data

If you have to analyze financial data, chances are that you will have to analyze multiple ranges of data to find the trends that exist over time. To easily visualize them, you would need to create charts that show multiple trends.В

The first thing you need to know is that Google Sheets require you to adjust the data sheets such that a single range of data is in a column, like in this way:

How to create a graph in google sheets

This is quite unusual, as we often write the data in this way:

How to create a graph in google sheets

Fortunately, the following steps are easier than what a Google search might tell you! Let us now learn how to create charts with multiple columns.

Flip Columns and Rows

You may first need to format the data so Google Sheets can create a proper multi-range chart. To flip columns and rows, do the following steps:

Step 1: Look for an empty space in the spreadsheet, and select a cell in that area.

How to create a graph in google sheets

Step 2: At that selected cell, type the following:

How to create a graph in google sheets

Step 3: Press enter.

How to create a graph in google sheets

You could either hide the original rows or delete the original rows. But, if you delete the original rows, the transposed rows will also be gone! To keep the transposed rows, you can follow our tutorial here.

Create a Chart with Multiple Ranges of Data

For this portion we will learn how to create a line chart with multiple ranges of data.В

Let us start with the same data set, but with a few adjustments to make it more readable:

How to create a graph in google sheets

Now, here are the steps:

Step 1: Select the data to be included in the chart, with the headings included:

How to create a graph in google sheets

Step 2: Click Insert on the menu, then click Chart.

How to create a graph in google sheets

Voila! A line chart now appears. We still need to improve it. As you can see, a Chart Editor Tab appears on the right corner.

How to create a graph in google sheets

To change the title, you can do the following:

Step 3: Click on the text box below the Title text in the Chart Editor tab on the right. Then type the title of the chart.

How to create a graph in google sheets

Step 4: The chart title is left-aligned, by default. To center it, click on the Align symbol under Title format (that would be the button with four lines and an arrow pointing downward). Then click on the Center symbol.В

How to create a graph in google sheets

Your chart title is now centered!

How to create a graph in google sheets

The Chart Editor tab also contains more customizable settings to improve the chart. For instance, you can do this:

Create charts with Google

How to create a graph in google sheets

  • Tweet
  • Share
  • Email
  • Tweet
  • Share
  • Email

What to Know

  • Open a spreadsheet or create a new one. Select cells and choose Insert >Chart; choose Bar for a bar chart and use the Chart editor to modify.
  • Or, choose Line, Area, Column, Pie, Scatter, Map, or another chart style. To edit a chart at any time, double-click to access the Chart Editor.
  • In the iOS or Android version of Sheets, select cells, and then tap Insert (plus sign) >Chart. Tap Type and select a chart style.

This article explains how to add various types of charts and graphs to your Google Sheets spreadsheet. There are dozens of variations available, including oft-used options like column and pie charts as well as lesser-known data visuals such as scatter plots and treemaps.

Making a Bar Graph

Create a bar graph, which can then be modified to a different type later if you wish.

Desktop/Laptop (most web browsers; Google Chrome preferred)

  1. Open an existing spreadsheet or create a new one from scratch.
  2. Enter all the data that you wish to use in your bar graph, if necessary. This data should typically be in table form, as shown in the accompanying screenshot.
  3. Select all the cells containing data that you wish to include in your bar graph, including headers if desired. You can choose to skip this step and define a data range after the chart has already been created, although doing it this way is typically much simpler.
  4. Choose the Insert option from the Google Sheets menu, located towards the top of the screen. When the drop-down list appears, click on Chart.
  5. Your chart will now appear, overlaying some of the cells in your spreadsheet. Select and drag it to the desired location. You can also adjust its size at this point by clicking and dragging the blue corner or side indicators accordingly.
  6. The Chart editor interface should also be visible, located on the right-hand side of your browser window. Click on the DATA header, if it’s not already selected. Next, select the drop-down menu in the Chart type section.
  7. A thumbnail image representing each available chart and graph type should now be displayed, broken down by category. Scroll down to the section labeled Bar and select the first option, Bar chart.
  8. If you skipped Step 1 and have yet to define the source for your bar graph, click on the button located in the Data range section and enter one or more groups of cells containing the data that you wish to be depicted.
  9. At this point, the basics of your bar graph should be in place. As you can see, there are many other customizable settings within the Chart editor interface that you can play around with until your graph’s layout and contents are exactly to your liking.

Android/iOS

  1. Launch the Google Sheets app.
  2. Open an existing spreadsheet or create a new one from scratch.
  3. Enter all data that you wish to use in your bar graph, if necessary. This data should typically be in table form, as shown in the accompanying screenshot.
  4. Select all the cells containing data that you wish to include in your bar graph, including headers if desired.
  5. Tap the Insert button, represented by a plus(+) symbol and located at the top of your screen.
  6. When the Insert menu appears, select Chart.
  7. A sample of what your chart looks like will now be displayed, accompanied by a number of configurable options. Tap the one labeled Type.
  8. A set of over a dozen charts and graphs should be visible, separated by category. Scroll down to the section labeled BAR and select the first option. It should be noted that some chart and graph types are only available on the computer version of Google Sheets and are not offered for Android or iOS devices.
  9. Tap the checkmark located in the upper left-hand corner of the screen.
  10. Your bar graph should now be in place, overlaying the existing cells in your spreadsheet. Drag and drop it to the desired location, preferably below or alongside the data table.

To edit your graph at a later time, simply double-click on it so that the Chart editor interface appears (browser-based version) or tap it and select the Edit Chart button (Android/iOS app).

Other Graph Types

How to create a graph in google sheets

In the example above we showed you how to create a bar graph, just one of many charts available in Google Sheets. By following the same steps and choosing a different type when prompted you can include one or more of the following in your spreadsheet. As you will see, some options are only available in the browser-based version of Google Sheets.

Line charts

  • Standard
  • Smooth
  • Combo

Area charts

  • Standard
  • Stacked area
  • 100% stacked area (browser only)
  • Stepped area
  • Stacked stepped area (browser only)
  • 100% stacked stepped area (browser only)

Column charts

  • Standard
  • Stacked
  • 100% stacked

Bar charts

  • Standard
  • Stacked
  • 100% stacked (browser only)

Pie charts

  • Standard
  • Doughnut
  • 3D

Scatter charts

  • Standard
  • Bubble

Map charts

  • Geo (browser only)
  • Geo with markers (browser only)

Miscellaneous charts

  • Waterfall (browser only)
  • Sparkline (browser only)
  • Histogram (browser only)
  • Radar (browser only)
  • Gauge (browser only)
  • Candlestick
  • Organizational (browser only)
  • Tree map (browser only)
  • Timeline (browser only)
  • Table (browser only)

Google Sheets is a convenient alternative to Excel, offering many functions in a cloud-based package. However, it can still be a challenge to read and understand large sheets of numerical data. Here’s how to make a graph in Google Sheets to visualize your information.

SHORT ANSWER

To add a chart or graph to Google Sheets, select the cells you want to include in your chart, then click Insert–> Chart.

KEY SECTIONS

How to make a graph in Google Sheets on a computer

Creating a chart in Google Sheets is similar to Excel but uses different buttons. We’ve grabbed our data from IDC, so you can always use that as an example and follow along.

First, highlight the data you want to include in your graph. After all, an empty chart won’t do much for your readers.

How to create a graph in google sheets

Next, click Insert–> Chart to find a selection of both charts and graphs.

How to create a graph in google sheets

You’ll probably notice that Google Sheets defaults to a stacked column chart. While common, it may not be the right option for everyone, so let’s dig into the Chart Editor on the right to explore customization.

Changing Charts

The first thing to do is select your preferred Chart type from the drop-down menu.

How to create a graph in google sheets

Google will give recommendations for chart types based on your data input. For example, a pie chart can accurately represent percentage data but doesn’t work to represent multiple time periods. Likewise, a bar chart might work for frequency data, but it would be overly complicated for how much data we have here.

We’ll choose a Line Chart for this example since it will help us illustrate the rise and fall of each manufacturer’s market share by quarter. You can also scroll down to verify that the X-Axis and Series match the information you’ve selected.

How to create a graph in google sheets

The last step is to head to the Customize tab. Here, you can tinker with titles and legends and change the color scheme of your chart. You can also click on the chart elements to jump to the specific menu.

How to make a graph in Google Sheets on Android or iOS

First, open a spreadsheet in the Google Sheets mobile app. Then, select the cells you want to include in your chart and tap Insert, represented by the ‘+’ icon.

How to create a graph in google sheets

From there, scroll down and tap Chart at the bottom of the screen.

How to create a graph in google sheets

Here, you can edit the chart type, titles, and color of your graph. When you’re done, tap the checkmark in the top left.

How to create a graph in google sheets

Now that you know how to make a chart in Google Sheets, it’s time to get out there and practice.

How do you make an XY graph in Google Sheets?

First, enter your X and Y data into separate columns in Google Sheets. Then highlight the data and click Insert–> Chart. From there, you can change the chart type to Scatter to make an XY graph.

How do I make a bar graph in Google Sheets?

Select the cell you want to include in your graph, then click Insert–> Chart. You can change the chart type to Bar under the Chart editor.

If you are using Excel, you have probably learned so far to make a graph. Graph makes your data look much better and visible. Your document users would have less difficulties to understand and interpret the data. Especially those who rely on their visual experience.

How can I make a graph?

It is very easy to make a graph in Excel. In case you don’t know how to do it, here is a short explanation below. Further in this text you will also learn how to make a graph in Google Sheets.

  • Open Excel and insert data (any version of Excel)
  • Select the data you want to present in the chart
  • Click on Insert button (next to the Home)
  • Choose a chart

How to create a graph in google sheets

The chart will appear in your spreadsheet and you will be able to move it. Here you can find more details on how to embellish your charts.

How to Make a Graph in Google Sheets

You don’t need to be skilled with Excel, to learn how to make a graph in Google sheets. You just need to have a gmail account, online access and a little bit of patience to follow this guide.

Google Drive is very convenient because you can store files and have an online access to them whenever you need it. The same way you work in Microsoft Office suite, you can work in Google Docs and Google sheets.

Google sheets is very similar to MS Excel, and now you will see how similar is it to make a graph in Google Sheets.

How to create a graph in google sheets

First, sign in to your gmail where your Google Sheets file is located. Or if you haven’t created a Google sheets file yet, click the New button in the Google Drive . Then click on Google Sheets as shown on the image above.

Then write data in your sheet and with the left mouse click, select only the data you want to present in one graph.

Click on the Insert menu and then on Chart .

How to create a graph in google sheets

The Chart editor will open on the right side of the screen. In the chart type drop-down menu, choose an appropriate chart. In this guide we will show you how to make a line graph in Google sheets.

How to create a graph in google sheets

Select the Line Chart , which is the first chart to choose from. Then go to Customize tab and set up other options.

How to create a graph in google sheets

For instance, you can choose the font and its color, for every line individually. You can change the style of the graph and the look of the gridlines as well. Just click on the thing you want to change, for instance gridlines, and you will see all options.

Did you get it?

Google Drive can be useful when you are away from the office or home computer and you need to finish something. It is also convenient if you are working with someone else in the same document. So one way or another, it wouldn’t hurt if you learn how to make a graph in Google Sheets. Your data will be presented visually, even though you didn’t use Excel.

Table of Contents

  • INTRODUCTION
  • WHAT ARE COMBO CHARTS IN GOOGLE SHEETS ?
  • WHERE IS THE OPTION TO CREATE COMBO CHARTS IN GOOGLE SHEETS ?
    • TOOLBAR BUTTON LOCATION FOR CHARTS INSERTION
    • MENU OPTION TO INSERT A COMBO CHART:
  • EXAMPLE TO MAKE A COMBO CHART IN GOOGLE SHEETS
    • EXAMPLE DETAILS
    • STEPS TO MAKE A COMBO CHART IN GOOGLE SHEETS :
  • HOW TO CHOOSE THE INDIVIDUAL CHART TYPES IN COMBO CHART IN GOOGLE SHEETS
    • EXAMPLE DETAILS
    • STEPS TO CHANGE INDIVIDUAL CHART TYPE IN COMBO CHART FOR GOOGLE SHEETS :
  • NOTE:
  • FAQs

INTRODUCTION

CHARTS are the graphic representation of any data . Google Sheets provide us a number of visualization options in the form of different charts and graphs etc.

GOOGLE SHEETS gives us a variety of charts which are beautiful, colorful, more customizable and more powerful.

In this article we are going to discuss COMBO CHARTS which is a combination of two charts on the same axes.

COMBO CHART IS THE TYPE OF CHART WHICH IS A COMBINATION OF MORE THAN ONE TYPE OF CHARTS IN GOOGLE SHEETS

For example, if we have a combination of line chart and column chart, we can get the following information at the same time.

In a line chart , slope tells the rate of increment or decrement whereas column chart simply marks the values.

In this article, we would learn to make a combo chart in google sheets and use it in google sheets.

WHAT ARE COMBO CHARTS IN GOOGLE SHEETS ?

THE COMBO CHARTS [ COMBINED CHARTS] IS A COMBINATION OF TWO OR MORE CHARTS IN GOOGLE SHEETS. WE CAN COMBINE MANY CHARTS TOGETHER SUCH AS LINE, COLUMN , AREA AND SO ON.

We can overlay two different charts or graphs on the same axes and compare the two different parameters.

Combination charts are created by transposing two or more charts on the same area.

WHERE IS THE OPTION TO CREATE COMBO CHARTS IN GOOGLE SHEETS ?

The COMBO chart can be easily inserted by the chart button on the toolbar itself.

The button location is shown in the picture below.

TOOLBAR BUTTON LOCATION FOR CHARTS INSERTION

  • Click the CHARTS BUTTON which will open the Chart Editor.
  • In the Charts Editor, Select COMBO CHART from the CHART TYPE DROP DOWN LIST as shown in the picture below.

MENU OPTION TO INSERT A COMBO CHART:

We can insert a chart using the Menu also as chart option is available in the menu too.

  • Go to INSERT MENU > CHART.
  • After clicking the CHART , CHART option will appear.
  • Choose COMBO CHART from the CHART TYPE DROP DOWN.
  • Charts Editor is exactly same as shown in the picture above. [ TOOLBAR BUTTON FOR CHARTS INSERTION ]

The location is shown below in the picture.

MENU OPTION LOCATION FOR INSERTING COMBO CHART

After clicking the CHARTS OPTION, follow the same procedure as in the TOOLBAR OPTIONS FROM S.NO. 2 onwards to choose from the given charts.

EXAMPLE TO MAKE A COMBO CHART IN GOOGLE SHEETS

EXAMPLE DETAILS

We can demonstrate the creation of chart using an example.

The procedure to insert a COMBO chart are as follows:

STEPS TO MAKE A COMBO CHART IN GOOGLE SHEETS :

  • The first requirement of any chart is data . So create a table containing the data. [ We have already created in the form of table above]
  • Refer to our data above, we have SALES DATA FOR 6 YEARS.
  • Select the complete table including the HEADER NAMES.
  • Go to TOOLBAR > CHARTS .
  • CHART EDITOR will open on the right side.
  • Click CHART TYPE and choose COMBO CHART from the drop down list.
  • The chart will be created as shown in the picture below.

The process is depicted in the picture below.

We can see that the three series are shown with the help of a column chart and two line charts in the same space.

After a few tweaks, here is our final combo chart.

FINAL COMBO CHART

HOW TO CHOOSE THE INDIVIDUAL CHART TYPES IN COMBO CHART IN GOOGLE SHEETS

EXAMPLE DETAILS

A need may arise when we want to choose the individual chart type for a particular series.

In our example, we have three series. Let us learn to find out the way to choose the individual chart type.

Currently , we have the following charts in our Combo chart.

Actual Sales and Difference are as a Line Chart and Projected Sales is shown as a column chart.

Let us change the Actual Sales to Column chart .

The procedure to insert a COMBO chart are as follows:

STEPS TO CHANGE INDIVIDUAL CHART TYPE IN COMBO CHART FOR GOOGLE SHEETS :

We have already created a combo chart in the previous section.Let us try to change the chart type of actual sales from LINE CHART to COLUMN CHART in the combo chart we created.

  • Double Click the chart to open the CHART EDITOR on the Right portion of screen.
  • In the CHART EDITOR, choose CUSTOMIZE TAB.
  • Go to SERIES options and click it.
  • The process is depicted in the picture below.
  • In the SERIES OPTIONS click the SERIES DROP DOWN as shown here and choose ACTUAL SALES.
  • Now click the TYPE DROPDOWN and choose COLUMNS to choose the COLUMN CHART TYPE.
  • The settings are shown in the picture below.

As we make the selections, the chart type of the series ACTUAL SALES will change immediately.

The final chart is shown below.

FINAL CHART AFTER CHANGING THE INDIVIDUAL CHART TYPE

This way, we can change the chart type of any given series and can change more options too.

FOR ALL OTHER TASKS LIKE CHANGING THE NAME OF THE CHART, CHANGING THE AXIS , CHANGING THE CHART STYLE ETC.

In this article, we learnt about the Combo Charts, how to create them, how to change the individual charts with the help of examples.

Google Sheets bar charts

Bar graphs are great when working with multiple groups of data. They are helpful when looking for patterns. Groups of data provide opportunities to look at data from different perspectives.

The data for this chart is shared with you here. Click this link to get a copy and follow along. The second tab in the sample worksheet includes data from multiple campuses.

Select the headings and data then click the Insert chart button.

This bar chart includes more information. This chart includes a legend. The legend in this chart runs across the top. The data in the chart is grouped by campus. The bars for the data appear in the order that came from the table.

Google tried to help format the titles but they need some work. The horizontal title is missing and we need to change the title from Grades to something else. Change the title from Grades to Campus. Go to the Chart editor panel and change the font size to 16 points.

Click on the axis and titles selector. Choose the Vertical Axis title.

The vertical axis title is empty. Click once in the title field and type Teachers.

Change the font size to 16 points.

Change the title to “Teachers by Campus” and change the font size to 16 points. Change the text alignment to center align.

Showing the values on each bar would be helpful. Go to the Series section.

Scroll down a little and place a checkmark in the Data labels option.

The data labels work well with all the values except Preschool. Only one campus has preschool teachers. It throws off the values for the other campuses.

We can format each data series. Click on the series selector.

Select the Preschool series.

Go to the text color option. Change the value from Auto to white.

Changing the font color to white forces the color to change across all campuses. The value of zero is still there but we can’t see it because it matches the background color.

Data can be viewed from different perspectives. The data in our current graph is displaying values for each campus. We can also modify the view so we are looking at the values for each grade level. Switch to the Setup section in the Chart editor.

Scroll down and remove the checkmark from switch rows or columns.

The values are now grouped by grade levels. Switching the data grouping changed the formatting. Switching between data groupings causes this issue. The better option is to create two separate charts of the same data. Place a checkmark back on the switch rows or columns box.

Click once on the chart and click the actions menu. Select Copy chart. The chart is placed in the computer’s memory. Click Edit in the menu and select Paste.

The copy is pasted above the original. Click once on the pasted copy and go to the setup section. Change the switch row or columns box.

This takes us back to the version that needs formatting.

There are some bars without values. Let’s take care of them first. Go to the series section in the customize panel.

Place a checkmark in the Data labels box.

We need to fix the values in Preschool. We can fix this in one of two ways. Let’s take a look at the easiest way first.

Click the Text color selector and choose white.

This works well when the bars are bright colors and the background is white. There is another option that allows us to target our customization. Place the text color back to Auto.

Find the Format data point option and click the Add button.

A data point selector dialogue opens.

Select a campus and the preschool that has a zero value. Click the OK button. Select white from the data color option.

Click the Add button again. Choose the next campus that has zero for the Preschool value. Change the data point color to white.

This option includes several steps but it does offer the flexibility to provide greater customization of text colors. Change the title of the slide to Teachers by Grade Level.

  • You can easily create a graph in Google Sheets to get a visual display of your data.
  • Once added, you can further customize the chart or graph so that it displays the information in the most comprehensible way.
  • Here’s how to use Google Sheets to create a graph to accompany your spreadsheet.

Spreadsheets can be extremely useful tools in themselves, but at a certain point, all that data can just be too much to process.

That’s when a chart or graph can help clarify things. If you use Google Sheets, you can easily add a chart to your existing spreadsheet in just a few simple steps.

Here’s what you need to know to get it done.

How to create a graph in Google Sheets

Creating a graph in Google Sheets is fairly simple as long as you’re logged into your Google account.

1. Open your Google Sheet, or create a new one by going to sheets.new and inputting your data into a sheet.

2. Select the cells you want to use in your chart by clicking the first cell and holding shift on your Mac or PC keyboard while selecting the other cells you want to include.

3. In the top toolbar, select “Insert” and then “Chart.”

4. Your chart or graph will then appear over your spreadsheet. Google Sheets will select whichever chart it deems as the best option for your data. However, you can always change the kind of chart or graph used by clicking the drop-down menu in the chart editor, located on the right-hand side of the screen.

September 16, 2021

Copy to Clipboard

Preparing information you’ve gathered for presentation is an important part of completing a successful presentation. Creating charts for presentations can affect the way audience members such as managers and stakeholders interpret your data. Learning how to create a chart in Google Sheets can help you display your data results in an efficient and easily understood way. In this article, we discuss how to make a chart in Google sheets, along with some tips for creating effective charts.

How can you use charts in Google sheets?

If you want to use a chart in Google Sheets, consider some of the following steps:

1. Open Google Sheets

To access Google Sheets, it’s necessary to have a Google account with the online software. You can open a new sheet by clicking Blank Sheet once you’ve logged in. You can also create a new sheet by going directly to sheets.new in your browser.

2. Select chart cells

Once you’ve created a new sheet for your graphs, begin placing the measurement data into your cells. When arranging your cells to create your graph, first consider what kind of graph you want to create from your data. If you want to make a bar graph, consider arranging your data vertically or horizontally as the graph appears. If you are creating a pie or dot graph, arranging your data in any order is acceptable. Once you’ve inserted your data, highlight all data cells by clicking and holding your first cell and dragging the mouse over each cell.

3. Use the top toolbar to insert a chart

Once you’ve highlighted all your cells, you can go to the top toolbar and select Insert. From the drop-down menu, click the Chart option. When you click, Sheets displays a default chart of your information based on the arrangement and contents of your data.

4. Customize your chart settings

When you have your initial chart, you can create customized features using the left sidebar. You can use this sidebar to change the type of chart Sheets uses. The sidebar allows you to adjust colors, data spacing metrics, display options and general appearance features.

Tips for making a chart in Google sheets

If you’re creating a chart within Google Sheets for your project, consider some of the following tips:

Use chart data settings to add changes

If you plan to add more data to your project over time, you can use data range specifications within data settings to change your graph as well. With your spreadsheet open, double click on the chart you want to change. On the right of the screen, click Setup. In the drop-down menu from Setup, click Data Range and then Grid. After clicking, you can change the cells that you want to include in your chart. If you want to add additional cells to the chart, you can click Add Another Range from the Setup drop-down menu.

Add chart grid lines to improve readability

Chart grid lines can make your data easier to read. You can add grid lines to any line, column, area, bar, scatter, histogram, radar, waterfall and candlestick chart. To add grid lines, double click the chart you want to change on your open spreadsheet. On the right, click Customize. From the drop-down menu, click Grid Lines. If your chart has horizontal and vertical grid lines, you can apply changes to either one or the other specifically by clicking Apply To.

To hide grid lines but keep axis labels, you can use the same color for both items by changing each. If you want to customize the number of grid lines you have, find the box under Major Grid Line Count or Minor Grid Line Count on the top toolbar to edit those numbers.

Edit data points for detailed charts

You can edit individual data points to create a detailed chart. With data point editing, you can change the points of a column, bar, line, scatter and combination charts. To edit data points, right click the bar or point in your open spreadsheet that you want to change. On the right, click Format Data Point. From this menu, you can customize data points to add borders to bars and columns, or edit point colors, thickness and shadow density.

Change chart elements to prepare for presentations

Within chart data settings, you can create your chart with as much detail as you need for your project. If you’re using your chart for a presentation, you may want to change some of these settings to help your chart colors, font sizes and text types to match with your presentation’s format. To change the background, font and other elements of your chart, double click the chart you want to change. On the right, click the Customize option. From that menu, click Chart Style. Under the Chart Style menu, you can customize colors and themes to match your needs.

You can also change titles, create subtitles or change title font pieces. You can add titles and subtitles to line, column, area, scatter, bar, waterfall, pie, histogram, candlestick, treemap and radar charts. To change titles and subtitles, double click on the chart you want to change on your open spreadsheet. On the right, click Customize, then click Chart And Axis Title. Next to Type, choose which title you want to add or change. Underneath the title text, you can type and edit your title. If you want to edit any title fonts later, double click the text.

Resize chart elements for transfer

Because Google Sheets may render a chart at a default size, this image may be either too small or too large for your presentation file. To change your chart size, double-click the chart you want to change on your open spreadsheet. When you double-click your chart, blue markers on each changeable edge appear. If you want to change your chart’s size, drag the blue markers until the chart is the appropriate size for your presentation. To export the file to an image file, right click the chart before choosing the option Save As Image.

Please note that none of the organizations mentioned in this article are affiliated with Indeed.

As an Amazon Associate and affiliate of other programs, I earn from qualifying purchases.

Adding a pie chart or bar graph to your content makes it more interesting and authoritative at the same time. However, most people still think that creating a graph is a tough task and needs some serious mathematics skills.

On the contrary, creating graphs is very easy and anyone who knows how to use the internet can do it. Yes, you can create awesome bar graphs and pie charts using various online tools.

However, in this tutorial, we teach you to create graphs in Google Sheets because it’s easy and free. So, without wasting any time lets dive into the tutorial.

How To Make A Chart In Google Sheets

Before we start, make sure you are ready with all the data that you want to put into the chart. Now once you have the data follow these steps to create charts in Google Sheets

Create a Chart

1. On your browser visit Google Sheets. Now add a new Blank sheet to create a graph and rename the sheet if you want.

How to create a graph in google sheets

2. Next, add the data with their respective value as shown in the screenshot below.

How to create a graph in google sheets

3. Now select/highlight all the data in the sheet and click on the insert chart icon on the top right corner.

How to create a graph in google sheets

4. Now as you do that, you will see a chart pops up on the screen with all the relevant data.

How to create a graph in google sheets

5. If you are happy with the chart then you download it in PNG, PDF, and SVG format and use it. Click on the three dots icon on the top right of the chart to access the download option

How to create a graph in google sheets

However, if you want to change the chart type to some other formats then keep reading this tutorial.

Change The Chart Type

1. On the right-hand side under the Chart editor tab, select the chart type box

How to create a graph in google sheets

2. Now you can select your desired chart type. Google Sheets have various chart formats, from pie chart and bar graphs to line, area and others.

How to create a graph in google sheets

3. Once you find your desired chart, select it and the main chart on the screen shall change accordingly.

How to create a graph in google sheets

Now you can either download this chart or you can further customize it.

Customize The Chart

If you want to make the chart more personalized then you can do that by customizing it and for that, you can follow these steps.

1. On the chart click on Edit chart. The chart editor will open on the right side, now select Customize.

How to create a graph in google sheets

2. Under customize settings you get various options like Chart style, Chart & axis titles, Series, Legends and much more.

How to create a graph in google sheets

Note: The customization options are different for different chart types.

3. To change the font style or chart’s foreground and background color you can select the chart style option. You can also change the chart layout from 2D to 3D using this option.

How to create a graph in google sheets

4. Similarly, if you want to add a title to the chart then you can do that by selecting the option Chart & axis titles. Here you can give your chart a title or a subtitle. Also, you can add a title to the X and Y-axis from here.

How to create a graph in google sheets

Now similarly, you can use all the options under the customize settings and make the chart more personalized. If you still face any problem while creating and customizing charts on Google Sheets then you can read this tutorial for help.

Conclusion

With this, we have come to the end of this article. We hope we help you out in creating charts in Google sheets. Also as you saw it is very easy to make charts in Google Sheets, you just need to fill the data and leave everything to Google sheets.

Moreover, you can create a different type of charts in it that meets all your requirements. In the end, we will just like to say that Google Sheets is an awesome free tool to create charts online and anyone can use it.

How to create a graph in google sheets

Many of the spending tracker templates built by Tiller Community member include charts, but you’re not limited to the charts in these community solutions.

You can easily create your own spreadsheet charts based on your spending data. In this blog, for example, I’m going to look at my spending across several categories per month for the entire year of 2020.

Visualize monthly spending with a simple pivot table or QUERY

A great way to do this is to start out with a pivot table or QUERY. You can learn how to do this in a few easy steps.

It’s a great way to get the data organized, but it’s not an engaging visual format.

So for those of you who’d like to digest this data with a little color, we’re going to give you a few quick steps to get this into a nice bar chart.

Get your spending data ready

In this example, we’ll start out by creating a pivot table to get our data for the chart. Again, the detailed instructions for that are here, but to recap you’ll select all the data on your transactions tab, open the Data menu from your Google Sheet and choose Pivot Table and choose to create a “new sheet” in your spreadsheet.

From there you can set the rows to pull in the Categories and the columns to pull in the Month. The chart values will be the Amounts.

How to create a graph in google sheets Monthly Spending Pivot table without category filters

Here’s where we’ll branch off from the original Monthly Spending Pivot Table blog post.

You’ll likely want to add a couple filters to your pivot table. In this example I want to look at my spending for each month for only some of my categories, specifically the ones that are “living and fixed.”

So, things like my cell phone bill, rent, health insurance, groceries, etc. In order to do this I’ll add a filter for “Category” and choose only the ones that I want to see right now.

Next, I’ll want to add another filter so that I’m only looking at 2020 data. I’ve been using Tiller since 2015, and I don’t really care to see all my historical data. I customized my sheet a little further so I have a Year column in my sheet. Then I can add a filter to only view 2020 transactions.

In the Filters settings I’ll add a filter for the Year column. Next, I’ll click Clear to deselect all the other years. Finally, I’ll select just 2020 and click OK.

Time to visualize your spending

Now we’ve got the data ready for our beautiful chart. This is the easy and fun part. I’ll select all the data in the pivot table by clicking cell A1.

I’ll hold down the SHIFT key on my laptop and then select the bottom right cell that’s not including any Grand Total data. For my case, it’s M15. I don’t want to include the Grand Total data because that is not a value I want in the chart.

Once I’ve selected the data I will then open the Insert menu from the Google Sheets navigation at the top and choose Chart. It’s going drop a chart into the sheet. From there I can use the sidebar to customize the chart type and other details. You’ll notice that some of the chart types are not available in this view because of the way the data is formatted.

How to create a graph in google sheets Use the sidebar to customize your Google Sheets chart

My favorite chart option for this analysis is the stacked bar chart that you’ll find if you scroll down a bit on the Chart Types list in the sidebar. After I click Insert I have a beautiful new chart visualizing my spending across several categories for each month in 2020.

As a last step I can customize it a bit more by updating the chart title and the horizontal and vertical axis titles. I can double click the chart name and the axis title to edit them.

How to create a graph in google sheets

Visualizing spending throughout the year with charts

I like to use this type of chart throughout the year, not just at year end, to visualize my spending. Now that it’s built you can edit the Category filters to review different categories or different months. The only thing to keep in mind when you edit the filters is that you may need to update the Chart’s selected range.

You can edit the selected range by double clicking on the chart to open the customization options in the sidebar. From there you can update the range to make sure it’s including all the updated categories or months. If you explore this advanced edit configuration you’ll also see you can switch to a different chart type and change the chart and axis titles.

These charts are an easy and powerful way to visualize your spending. If you want multiple charts to visualize your spending you can create a new pivot table on a separate sheet using the same process as before or you can copy the entire pivot table and paste it elsewhere on that same sheet. From there you can customize the new pivot table to give you a different data set. The possibilities are endless!

How to create a graph in google sheets

Create a chart in Google Sheets to call out specific data or provide a unique way to view it. You can easily customize the chart and its appearance.

Sometimes a spreadsheet can contain an enormous amount of data. So when it’s time to analyze that data or share the sheet with someone else, it can be overwhelming. However, a tool like a graph or chart not only displays your data in a unique form but also let you call out certain data for a clearer visual amidst the chaos.

Like Microsoft Excel, Google Sheets offers a handy feature for creating a chart easily. You can choose from several chart types and completely customize the chart for the ideal appearance.

Create a Chart in Google Sheets

If you have data that would fit perfectly into a chart, head to Google Sheets, sign in, and open your spreadsheet. Follow these steps to create the chart.

  1. Select the data for the chart. You can do this by dragging through the cells you want to use.
  2. Click Insert > Chart from the menu.
  3. You’ll immediately see your chart, using a suggested style. And the Chart Editor will open on the right. So you can click the Chart Type drop-down list and pick a different style like a line, area, bar, or pie chart.

How to create a graph in google sheets

Depending on the type of chart you use, the remaining Setup options in the Chart Editor will vary. For instance, if you choose a column, area, or waterfall chart, you can apply Stacking.

Data Range

For all chart types, you can see the Data Range. So if you need to make an adjustment or want to add another range, click the Select Data Range icon.

How to create a graph in google sheets

Axis and Aggregate

You can remove or add labels to the X- or Y-axis by clicking the Options (three dots) icon on the right of that item. If you’d like to Aggregate the data, check that box and then pick average, sum, count, or another option in the drop-down list.

How to create a graph in google sheets

Series

You have options to remove a series or add labels by clicking the three dots to the right of one. Or you can click Add Series at the bottom of the list for additional data.

Other Options

At the bottom of the Chart Editor, you also have the ability to switch rows and columns, use row 1 as chart headers, and use column A as labels. Just check the boxes next to the items you want to apply.

Move or Resize

  • To move your chart to a different spot on your sheet, simply grab it and drag where you want it.
  • To resize your chart, select it and drag from one of the corners or borders.

Customize Your Chart

Once you create your chart and organize the data as you like, you have ways to customize the chart. This lets you apply changes to the appearance like color, style, and gridlines.

If you’ve already closed the Chart Editor, you can reopen it easily. Click the three dots on the top right of the chart and select Edit Chart.

How to create a graph in google sheets

In the Chart Editor, click the Customize tab at the top. You’ll see several options for changing the appearance of your chart, each can be collapsed or expanded. These options vary depending on your chart type.

Chart Style: Change the background color, font, border, and overall look.

Chart & Axis Titles: Add text for the chart title, subtitle, horizontal, or vertical axis titles. Then, choose the font style, size, format, and color for those you use.

Series: Format the axis position and data point and select colors for items in the series.

How to create a graph in google sheets

Legend: Add, remove, and position the legend on the chart. You can also format the font.

Horizontal Axis and Vertical Axis: Adjust the font style, size, format, and color for the selected axis. You also have options to slant the labels on the horizontal axis and choose a scale factor for the vertical axis.

Gridlines and Ticks: Choose the spacing types and counts, add major and minor ticks, and pick the gridline color.

How to create a graph in google sheets

Again, the options in the Customize section of the Chart Editor depend on the chart you use. So if you pick a pie chart, for example, you can add a donut hole and select its size.

Time-Saving Tip: Not sure which section of the Chart Editor you need to access for a particular part of the chart? Make sure the Chart Editor is open and then click the item directly on the chart. This action will display the expanded corresponding area in the Chart Editor to make your edits.

How to create a graph in google sheets

Create a Chart in Google Sheets for Data Visualization

If you want to call attention to particular data or simply view your data in a visually pleasing way, create a chart in Google Sheets. You have complete flexibility with how your chart looks and the data it shows.

Need a little help with charts in Microsoft Excel? Take a look at our walk-through for creating a Gantt chart in Excel. Or check out how to create a pie chart in Excel 2010 if you are running an older version of Office.

Simple and Easy– Awesome for Stock Traders or Investors using Google Sheets.

Formula featured “=GOOGLEFINANCE(Stock, “ALL”, DATE(year(today())-5, 1, 1), TODAY(), “weekly”)”

Auto-Populated Columns: Date, Open, Low, High, Close, Volume

You can easily convert the populated table into a chart by clicking Insert>Chart and changing the chart to a Candlestick. Google Sheets can be weird in that it doesn’t align the columns correctly. You’ll need to change which columns the chart pulls from.

After that, you can send it to its own page, publish it, customize it, embed it in your website, and more. Using the method in this video, you can even change the stock ticker easily (dynamic charts) and populate the chart of the stocks on the exchanges.

Example

GOOGLEFINANCE(“AAPL”, “All”, DATE(2016,1,1), DATE(2019,12,31), “DAILY”)

Syntax (how the formula is made)

GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date], [interval])

  • ticker – the symbol for the stock. It’s always a good idea to use the exchange in front like “NASDAQ:AAPL” instead of “AAPL” to avoid discrepancies, but you’ll see results with just the symbol.
  • attribute – what item about the stock you’re looking for… it must be listed in the formula using quotes, example: “price”, not price.
    • List from Google Support:
      • “price” – Real-time price (delayed by up to 20 minutes)
      • “priceopen” – The price at market open.
      • “high” – day’s high price.
      • “low” – day’s low price.
      • “volume” – day’s trading volume.
      • “marketcap” – The stock’s market capitalization
      • “tradetime” – The time of the last trade (when the quoted price was captured).
      • “volumeavg” – The average daily trading volume.
      • “pe” – Price/Earnings ratio (for investors)
      • “eps” – Earnings per share (for investors)
      • “high52” – 52-week high
      • “low52” – 52-week low
      • “change” – The price change in currency since the previous trading day’s close.
      • “beta” – The beta value (typically for investors).
      • “changepct” – The % change in price since the previous trading day’s close.
      • “closeyest” – The previous market day’s closing price.
      • “shares” – The number of outstanding shares.
    • attribute you would typically use to build a table for the specified date(s) below
      • “open” – Opening price
      • “close” – Closing price
      • “high” – High price
      • “low” – Low price
      • “volume” – Volume on the day(s)
      • “all” – All of the above– used if you want to make a table>chart
    • attribute for mutual fund data:
      • “closeyest” – The previous day’s closing price.
      • “date” – The date at which the net asset value was reported.
      • “returnytd” – The year-to-date return.
      • “netassets” – The net assets.
      • “change” – The change in the most recently reported net asset value and the one immediately prior.
      • “changepct” – The percentage change in the net asset value.
      • “yieldpct” – The distribution yield, the sum of the prior 12 months’ income distributions (stock dividends and fixed income interest payments) and net asset value gains divided by the previous month’s net asset value number.
      • “returnday” – One-day total return.
      • “return1” – One-week total return.
      • “return4” – Four-week total return.
      • “return13” – Thirteen-week total return.
      • “return52” – Fifty-two-week (annual) total return.
      • “return156” – 156-week (3-year) total return.
      • “return260” – 260-week (5-year) total return.
      • “incomedividend” – The amount of the most recent cash distribution.
      • “incomedividenddate” – The date of the most recent cash distribution.
      • “capitalgain” – The amount of the most recent capital gain distribution.
      • “morningstarrating” – The Morningstar “star” rating.
      • “expenseratio” – The fund’s expense ratio.
  • start_date – [ OPTIONAL ] – The start date when fetching historical data.
    • If start_date is specified but end_date|num_days is not, only the single day’s data is returned.
  • end_date|num_days – [ OPTIONAL ] – The end date when fetching historical data, or the number of days from start_date for which to return data.
  • interval – [ OPTIONAL ] – The frequency of returned data; either “DAILY” or “WEEKLY”.
    • interval can alternatively be specified as 1 or 7 . Other numeric values are disallowed.

Notes from Google Support

Usage restrictions: The data is not for financial industry professional use or use by other professionals at non-financial firms (including government entities). Professional use may be subject to additional licensing fees from a third-party data provider. Source: Google Support

Graphs are essential to any good report and with Google sheets being a hugely popular option for spreadsheets these days, it only makes sense that you would want to know how to integrate graphs into it. This is what we will be talking about in this article.

Step by step tutorial for creating a chart in Google Sheets:

Time needed: 5 minutes.

We will be going through the steps that will allow you to create some awesome graphs, as well as the best ways in which you can optimize your reports to accommodate this need. It makes a lot of sense that you would want to make the best impression when you are conducting your report, so be sure to read everything closely.

    Open or Create a Google Sheet

Using a new or an existing Google Sheet, input the relevant details that you are trying to make a graph of. If you already have a vast and complicated report, you can certainly use that. However, if you are not that familiar with this platform yet, it would be best to have a more simplified report with two columns. One will be for the subject and the other will be for the figures.
How to create a graph in google sheets

Select insert chart

Select the Insert tool on the toolbar and click on the chart command on the dropdown menu.
How to create a graph in google sheets

Input Relevant Data

Using the editor tool on the right-hand side of the sheet, input the relevant parameters that will be included in your graph. In this case, we will be highting the two columns and all of the filled rows.
How to create a graph in google sheets

Check the Graph

Once you hit the Ok button, you will end up with a graph that looks like the example below.
If you want, though, you can also use the chart editor menu to change how the graph will look.
How to create a graph in google sheets

Change the type of the chart

If you want, though, you can also use the chart editor menu to change how the graph will look.
How to create a graph in google sheets

So, there you have it. You now know how to create an excellent graph when you are using Google Sheet. Using this same method, you can actually also create charts of different shapes and colors.

A graph is basically a visual representation of parameters that typically involve figures that correspond to particular subjects or items. It is often also referred to as a chart, though, there are some start differences between these two visualizations. To start with, there is the matter of shape and typical use.
Charts are often favored more for abstract or broader concepts rather than meticulous, specific details that deal with the minutiae of factors and figures. To put this in context, you can take into consideration such things as age, population, and average lifespans when using a chart.
These types of visual representations are meant to convey a sense of awe and to impress the audience. It is not necessarily about informing them.
On the other hand, you can take specific individuals and their work performance right down to the decimals when you are using graphs. This is why you would often find graphs used in presentations for quarterly financial reports or by scientific studies and surveys.
The graphics are basically meant to educate the audience and let them know exactly what they are dealing with. This is important when trying to bring in more money from investors and the like.

You might think that a very detailed spreadsheet is already enough to make your presentation impressive, but while there is certainly value to well-filled rows and columns, they are often not enough. To really impress upon your audience just how awesome you are doing, you need graphs.
A lot of this has to do with the tendency of the human brain to zone out whenever numbers start hitting several digits, especially when there are decimals involved. Having to focus on all those cells with designated figures can be quite taxing on the mind.
Your audience would need to concentrate really hard in order to understand exactly what it is they are looking at.
On the other hand, if you have graphs, the impact is different. Seeing all of those bars just zipping sideways or upwards has a much different effect compared to mere numbers and letters. Even if the differences between the given figures are not that huge, just the presence of the graph automatically makes your presentation seem more credible.
While this may seem a little questionable, there is also the matter of visual trickery in the inclusion of graphs. Simply put, it takes a longer time for the implications of particular figures to really sink in if they are presented as graphs. Numbers are serious and grating, while graphs have more gravitas and mystique.

You might think that since you are dealing with graphs here, why not just use other types of spreadsheets for your troubles? Why would you use Google Sheets specifically for this task? Well, there are a lot of advantages that come with using this particular option.
To start with, you can access it from practically any device in any location in the world as long as there is an internet connection. You won’t necessarily need to bring your own device, either, since you can just borrow from someone else. Of course, it is always advisable for you to bring your own gadget, but it’s always nice to have options.
Then there is the matter of being able to share access to the spreadsheet. If this is a collaborative work, then it makes sense that you would want the people you are working with to be able to access the document any time.
This saves you a lot of time and effort because now, they don’t need to ask for permission whenever they have to make changes or do their job. In cases where you divided the responsibilities, this makes the work a lot more efficient.