How To Make A Chart On Google Sheets

To make a chart on Google Sheets, you need to select your data, click on the “Insert” tab, choose the type of chart you want, and customize it according to your preferences.

Google Sheets is a powerful tool that allows users to create, edit, and collaborate on spreadsheets online. From simple calculations to complex data analysis, Sheets offers a wide range of features to streamline your work. One such feature that can greatly enhance your spreadsheet presentations is the ability to create charts. Whether you’re visualizing statistics, comparing data trends, or presenting information in a more engaging way, charts can help you convey your message effectively. In this blog post, we will walk you through a step-by-step guide on how to make a chart on Google Sheets. So, let’s dive in and unlock the potential of data visualization with Google Sheets!

How To Make A Chart On Google Sheets: Step-by-Step


Step 1: Open Google Sheets,

To access your Google Drive, simply go to the Google Drive website or open the Google Drive app on your device. From there, you can create a new Google Sheets document or open an existing one.

Next Step

Step 2: Input or Select Your Data,

To create a chart in a spreadsheet, input your desired data either manually or select the existing data cells. These selected cells will form the basis of your chart, enabling you to visualize and analyze the information more effectively.

Next Step

Step 3: Go to “Insert” Menu,

In your Google Sheets toolbar, you will find an option called “Insert”. Simply click on it and a drop-down menu will appear, providing various options to enhance your spreadsheet functionality effortlessly.

Next Step

Step 4: Click on “Chart”,

From the drop-down menu, select the “Chart” option to open the Chart editor on the right side of your screen. This tool allows you to customize your chart’s appearance and data, providing a clearer visualization of your information.

Next Step

Step 5: Specify Chart Type,

After opening the Chart editor, locate the “Chart type” drop-down menu. This menu offers different formats such as bar graphs, line charts, and pie charts. Choose the format that best reflects and presents your data effectively.

Next Step

Step 6: Adjust Data Range,

It is crucial to double-check the data range in the Chart editor to ensure that it precisely matches the data you want to represent in your chart.

Next Step

Step 7: Customize Your Chart,

Customize your chart effortlessly by navigating to the “Customize” tab in the Chart editor. From there, modify element colors, insert a title, adjust the legend, and explore numerous additional options for personalized chart creation.

Next Step

Step 8: Insert the Chart,

After clicking the blue “Insert” button in the Chart editor, the chart will be inserted into your Google Sheets document. It can be moved by clicking and dragging, and resized by clicking on the corners.

Next Step

Step 9: Save Your Work,

Google Sheets automatically saves your work, but it’s essential to manually save your document before closing to ensure all changes are securely saved.

Next Step

Step 10: Export if Needed,

Once you have chosen to export your chart, simply click on the three dots located in the upper right corner of the chart. From there, select “Download” and choose the desired image format to save your chart in.


In conclusion, creating charts on Google Sheets is a simple and effective way to visualize data and gain valuable insights. With its intuitive interface and a wide range of chart options, Google Sheets provides users with the tools they need to present data in a clear and visually appealing manner. By following the step-by-step guide outlined in this blog post, you can easily create professional-looking charts that enhance your data analysis and presentation skills. So whether you’re a student, a professional, or simply someone looking to organize and visualize data, Google Sheets is the perfect tool to help you create impressive charts effortlessly. Start exploring the power of charts on Google Sheets and unlock new ways to present your data today!

Table of Contents