Welcome to The TechVin, here in this article, you are going to learn How to Make a Graph In Google Sheets easily. If you want to know how to make a creative graph in google sheets then read the complete article without skip any part. You will learn the complete process to make a graph and you will also learn about the tools that are important to make any type of graph.
The graph is the best way to visualize the data. With the help of graphs and diagrams, we can easily convey any information and data. In the google sheets, it is too easy to make any graph and also easy to make a graph more attractive and creative. So without wasting time let’s start gaining the knowledge and start the learning for creating a graph in google sheets.
How to Make a Graph In Google Sheets
It is easy to insert the chart in the Google Sheets. If you want to make the creative and amazing graph then you must learn the use of tools that are provided by the google sheets. In this article, we will learn the use of all tools but first we will learn how to insert a chart in google sheets. This is the first step of How to Make a Graph in Google Sheets.
- Firstly, you have to open the Google Sheets on your PC. You can click on Google Sheets to open it.
- Open the spreadsheet in which you want to make the graph.
- Select the data of which you want to make a graph. You have to just highlight the data in your sheets. If you don’t have the data in your sheet then fill the data first and then select it.
- Now, click on the Insert tab in the Menu bar.
- Click on the Chart option of the drop-down menu. In the Google Sheet, the graph is known as its synonym Chart.
- When you click on it then you can see that your chart is inserted in the google sheet. This graph is a suggested graph that suits your data. But if you want to change it then read the complete article.
- But it not so perfect graph as you want. If you want to make this graph perfect then you have to edit this graph. In all the below ways, you will learn How to edit the graph and make it creative.
This process is just used to insert the graph or chart. The main process to make the graph, you will learn in the lower ways. Because the editing is the main part to make any graph. So let’s see How to Make a Graph in Google Sheets.
How to Change the Graph Type In Google Sheets
Most of the time, you don’t get the chart which you want. So if you want to make the chart as your choice then you can learn how to change the graph in google sheets. Once you insert the graph in the google sheets. After that, you have to follow the below process.
- Click on anywhere in the graph or chart.
- Now click on the three dots which are available in the top right corner in the graph.
- After that, you have to click on the first option of Edit the Chart.
- When you will click on it then a menu will open from your right side in google sheet.
- In this menu, you have to click on the setup and then you have to click on the option of Chart type. This is the first option in the setup section.
- Now you can see the different types of charts in this section. The first section in this is the menu is of the suggested chart. In the suggested chart, you can see all the charts (Graphs) that suits your data. By the way you can scroll it down and choose the graph which you want.
So these are the complete steps that you have to follow to change the graph (chart) type. If you want to learn how to make a graph in excel then you can also learn it. You need to just click on the how to make a graph in excel to learn it.
How to Add or Edit Titles of Axis and Graph
The title is the name of the graph that you have made in your google sheets. You must add a title to the graph. Because it is the most important and the title is the identity of the graph. So never forget to give the title to your graph. If you want to make a perfect and creative graph then it is most important to give the names to the graph and axis of the graph. We can add the title to the graph and the axis graph easily. We have divided this process into two parts. The first is to add the title in the graph and the second is to add the title to the axis of the graph.
How to Add Graph Title In Graph of Google Sheets
- First of all, you have to double click on your graph. You can also single click on your graph and then click on three dots that are available in the top right corner.
- One menu will open from your right side of google sheets. In this menu you to main sections in which you have to click on the option of Customize.
- After that, click on the option of the Chart & axis titles.
- Now you have to type the title of your graph in the text box of the title text.
- You have some tools to edit the text of your title. Using these tools, you can change the color, font, text size, alignment, and also you can make it bold or italic.
How to Add Title of Axis of Graph In Google Sheets
- Double click on the chart to edit add the axis title.
- Now click on the customize option.
- After that, you have to click on the option of the Chart & axis titles.
- Now click on the chart title and select the axis of which you want to add the title.
- Once you have select the axis and then you have to type your title in the text box of the title text.
- If you want to change the color, font, text size, and alignment then you can do it also with the help of tools that are available in the below of your title text box.
SO these are the complete steps that you have to follow to add the title and the axis titles to your graph. If you want to learn How to Merge Cells in Google sheets then you can click it to learn it.
How to Make a 3D Graph In Google Sheets
If you want to make a 3D graph in google sheets then first you have to complete all the upper steps and ways that we have described. After that, you can make your graph 3D. So when you will complete these steps then follow the below steps to make a 3D graph in google sheets.
- First of all, you have to double click on your graph. You can also click anywhere in your graph and then click on the three dots that are available in the top right corner of the graph.
- Now you have to click on the section of the customize.
- After that, you have to click on the first option of Chart style.
- You have to tick the box of the 3D which is available in the opened menu. When you click on the chart style then you can see some options and tools by which you can change your chart completely.
- Now you can see that your graph is changed to the 3D graph.
So these are the instructions that you have to follow to make a 3D graph in google sheets.
How to Create Folders in Gmail ←Click on it to read it.
Google Sheets is the best spreadsheet software that provides all the services free to its users. In this article, we talked about one best service provided by the google sheets. We talked about How to Make a Graph In Google Sheets and the use of their tools. In Google Sheets, it is easy to make a creative and attractive graph. If you have read the complete article then you can make any type of graph easily in the google sheets. Now you can start making the graph in your spreadsheet. Before making a graph, if you have time then you can read the below-related information.
If you have any more questions and queries related to this topic then you can ask us. You can write your query in the comment box. We will try to reply you as soon as possible and we will help you to solve your problem. If you want to know more about google sheets and if you want more tutorials then you can read the tutorials on our website. We have lots of amazing and helpful tutorial that will increase your knowledge of google sheets.
You can also follow us on social media websites like Facebook and Twitter to get the regular updates of new articles. You can also ask us the questions related to office suite softwares on our social media sites. We will help you to solve your problem and we will share the information that has the solution to your problem. You can click on the social media icon which is available on the upper side of the section of recent posts to follow us.
Now I hope that you have learned How to Make a Graph in Google Sheet creatively. If you find this article helpful and if you liked this article then share this article with your friends. You need to just click on any social media icon that you can see on the screen to share the article. In the last, I just want to say that thanks for reading and keep increasing your knowledge.