How To Make A Bar Graph In Google Sheets

To create a bar graph in Google Sheets, you need to input your data, select it, click on the ‘Insert’ tab, choose ‘Chart,’ and then select ‘Bar’ as the chart type.

Google Sheets is a powerful and versatile tool that can be used for various data analysis and visualization tasks. One of the most common methods of visually representing data is through bar graphs, which provide a clear and concise way to compare different categories or groups. Whether you are a student analyzing survey results, a professional presenting sales figures, or someone simply wanting to present data in a visually appealing manner, learning how to make a bar graph in Google Sheets can be a useful skill. In this blog post, we will guide you through the steps to create bar graphs in Google Sheets, enabling you to better convey your data and make impactful presentations.

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


Step 1: Data Preparation

Before creating a bar graph, gather and organize the required data in a Google Sheets document by listing them in rows or columns. Each row or column will correspond to a distinct bar in the graph.

Next Step

Step 2: Select the Data

Once you have organized your data into a tabular format, use the highlighting or selection feature to choose the specific data you wish to visualize on a graph. You can even opt to include column headers in order to enhance your graph’s clarity.

Next Step

Step 3: Click on the Chart Button

After selecting your data, locate the “Insert Chart” button in the menu bar at the top of the Google Sheets page. This will bring up a variety of chart options for you to choose from.

Next Step

Step 4: Select the Chart Type

On the right side of your screen, you will find the Chart Editor sidebar. Scroll down to find and select ‘Bar chart’ from the available options.

Next Step

Step 5: Customize your graph

Using the Chart Editor sidebar’s ‘Customize’ tab, personalize your bar graph effortlessly. Modify colors, data labels, title, and legend to create a visually appealing chart tailored to your needs.

Next Step

Step 6: Save Your Bar Graph

After customizing your graph in Google Sheets, remember to manually save your work to ensure it is securely embedded in your Sheet and not lost.


With the help of Google Sheets, creating a bar graph has never been easier. By following the step-by-step process outlined in this blog post, you can now present your data visually in a professional and organized manner. Whether you are a student, a business professional, or simply someone who needs to visualize data, Google Sheets is a powerful tool that can help you create bar graphs effortlessly. So go ahead, give it a try, and enhance your data analysis skills with the use of bar graphs in Google Sheets.

Table of Contents