How To Make Graph In Google Sheets

To make a graph in Google Sheets, you can select the data range and choose the desired graph type from the “Insert” menu.

Graphs and charts are essential tools for visually representing data, whether you are analyzing trends in sales figures or comparing different variables. When it comes to creating graphs, Google Sheets provides a user-friendly and accessible platform. In this blog post, we will walk you through the process of creating a graph in Google Sheets, exploring its various features and customization options. Whether you are a business professional, a student, or anyone in need of translating raw data into meaningful visualizations, this guide will equip you with the necessary skills to effectively utilize Google Sheets’ graphing capabilities. So, let’s dive in and discover how to make stunning graphs that will bring your data to life.

How To Make Graph In Google Sheets: Step-by-Step


Step 1: Open Google Sheets,

Start by opening Google Sheets. If you don’t have a Google account, create one. After logging in or creating your account, go to Google Sheets in the Google Apps menu on the top right corner of your Google homepage.

Next Step

Step 2: Enter or Import Data,

To input data into Google Sheets, either manually type into cells or import a file. To import, go to “File”, click “import”, upload the file, and choose “replace spreadsheet” to update with your data.

Next Step

Step 3: Select Data,

To create a graph, highlight and select the data you want to use. This includes both the category (dates, names) and the values (sales, temperature readings). Left-click and drag from the beginning of your data until it’s completely selected.

Next Step

Step 4: Choose Chart Type,

In the site’s top menu, click “Insert” to access the chart options. Choose the chart type from the panel on the right. Use the “Chart type” drop-down menu to select the appropriate graph type.

Next Step

Step 5: Customize the Graph,

In addition to changing the title, labels, legend, colors, and more of your graph, you can further customize its appearance and functionality by exploring the various settings in the “Customize” tab of the chart editor.

Next Step

Step 6: Save and Share your Graph,

Once your graph is created, it will be saved in Google Sheets. Options like downloading, printing, or publishing the graph can be accessed by clicking on the three-dot icon at the graph’s top right corner.


In conclusion, making graphs in Google Sheets is a simple yet powerful tool that can greatly enhance your data analysis and presentation abilities. Whether you are a student, a business professional, or a researcher, learning how to create and customize graphs in Google Sheets is a valuable skill to have.

By following the step-by-step guide provided in this blog post, you can easily create various types of graphs such as bar charts, line graphs, and pie charts. Additionally, you can customize the appearance of your graphs by altering colors, fonts, and data labels to suit your preferences or brand guidelines.

Moreover, Google Sheets offers a collaborative environment where multiple team members can work simultaneously on a graph, making it an excellent choice for group projects or collaborative data analysis. The sharing and accessibility features of Google Sheets also allow you to easily share your graphs with others or embed them in presentations or reports.

Overall, Google Sheets provides a user-friendly platform for creating professional graphs without the need for any advanced software or technical skills. So why wait? Start exploring the world of visual data representation in Google Sheets and make your data come to life!

Table of Contents