Google Sheets is a useful online tool that lets you edit and manage spreadsheets on any system or device by logging in using your Google account. Many features are embedded in this tool by Google, and one of them is the ability to add graphs to it. Just like Microsoft Excel, Google Sheets also lets you add any type of graph that you want for your data on the spreadsheet.
Most people work on Microsoft Excel and are unaware of how to add graphs in Google Sheets. This article is a guide for those people who are wondering about adding graphs to a spreadsheet in Google Sheets. We will also show you how you can customize and design your graph according to your preference. So without further ado, let’s get into it.
How to add graphs in Google Sheets?
Like Microsoft Excel, Google Sheets also refers to all types of graphs as charts. So while following this guide, one will encounter the chart word a lot. But you should not be confused as it is just a term used by Google to denote graphs and charts together. And you get all sorts of graph setups in Google sheets, from the simple ones like the line and bar charts to more complex ones like candlestick and radar charts.
- Open up Google Sheets Spreadsheet and then select the data for which you want to create the chart.
- Click on Insert and then choose Insert. This will open up the Chart Editor Tool and also set up a line chart or bar chart for the data that you have selected in the spreadsheet.
Sometimes the Chart Editor tool does not show up. If that happens with you, then double click on the chart, and the menu will show up on the right side.
Customizing your chart:
In the Chart Editor tool, you will see two tabs, Setup and Customize. Using the Setup and Customize tab, you can design your chart according to your liking.
Choosing the type of chart:
There are different charts, like Pie, Column, Bar, Area, line, and more. You can set whichever type of graph you want for your data in the setup tab. In the setup tab, the first option you will see is Chart type. Clicking on it will open up a drop-down menu where you can select the type of graph that you want. By default, Google sheets assign a bar graph or column graph for your selected data. It depends on the type of data selected before inserting a chart.
Additionally, there are options for stacking, data range selection, and more in the setup, which you can tweak around and set according to your liking.
Changing the chart style:
You can make all sorts of visual changes like Background color, Font, Chart border color, and more for your chart. You will see the option Chart Style under the customize tab, and there you will find these settings.
Adding Chart and Axis titles:
By default, you will get a chart title for your chart, depending on the data selected for the representation. But you can edit it manually and set a title that you want. You can even add axis titles if you are working on a more detailed chart.
You will find the option for it in the Customize tab. Just click on Chart & Axis titles, and it will open up a menu. At the top of this menu, you will find a drop-down menu with Chart title selected as default. You can then set the title text, title font, title font size, title format, and title font color for your Chart title. Similarly, you can click on the drop-down menu and set Chart subtitle, Horizontal Axis title, and Vertical Axis title.
Besides the few features mentioned above, there are a lot of other things that you can tweak around to customize and set up the graph precisely to your liking or requirement.
So that is how you add and make necessary customizations to a graph in Google Sheet. If you have any questions or queries about this guide, then comment down below, and we will get back to you. Also, check out our other articles on iPhone tips and tricks, Android tips and tricks, PC tips and tricks, and more for more useful information.