How to Make a Graph in Google Sheets. A complex spreadsheet can be very difficult to read through and understand.
If you are using Google Sheets, inserting graphs to your spreadsheet can help you present your data differently for easier reading. Here is How to Make a Graph In Google Sheets
Before I begin, you should know that there will be a slight difference in terminology. Google Sheets refers to all types of graphs as charts just Like Microsoft Excel.
You can use the Chart Editor tool to create these graphs and charts in Google Sheets.
What Is Google Spreadsheet?
Google Spreadsheets is Web-based software that is available on all platforms.
This application permits users to create, view and modify spreadsheets within minutes. Spreadsheets can also be saved as HTML format.
How to use Google Sheets
- Download and install the Google Sheets app Play Store.
- Create, view or modify any spreadsheet.
- Share your work with others online.
Insert a Chart into Google Sheets
You can create various 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 begin, open your Google Sheets spreadsheet and choose the data you want to use to create your chart. Click Insert > Chart > and open the Chart Editor tool.
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.
Change Chart Type Using the Chart Editor Tool
You can always make use of 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, select a different 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.
Once selected, your chart will automatically 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 once the chart is created, and also add additional axis titles to make your chart easy to understand.
In the Chart Editor tool, click the “Customize” tab and then click “Chart & Axis Titles” to display the submenu.
Customize Chart Titles
Google Sheets will create 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 whatever you want in the “Title Text” box.
Your chart title will automatically change once you have 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 does not automatically 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 side of your chart, depending on your chart type.
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.
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.
See Also: How to use Google Advanced Image Search
Change Chart Colors, Fonts, and Style
The “Customize” tab within the Chart Editor tool provides different 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.
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.
Google Sheets’ Advantages
- Working at Scale.
- Creating Charts and graphs
- Linking Between Sheets in Different Files.
- Working with Plugins.
- Connecting to External Data Sources.
You should have a glimpse of How to Make a Graph In Google Sheets after reading this post.
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.