✦Template Printable Ideas Insights

Create Simple Google Sheets Chart: A Beginner's Guide

By

Google Sheets, a powerful tool in the Google Drive suite, is well-known for its versatility, and creating simple charts is just one of its many capabilities. Whether you're analyzing data or presenting information visually, charts can make complex data more accessible. Let's explore the step-by-step process to create a simple chart in Google Sheets.

Before we dive in, ensure you have Google Sheets open and you've created or chosen a sheet with the data you want to visualize. For this guide, we'll use a simple dataset with columns for 'Fruits', 'Apples', 'Oranges', and 'Bananas'.

Selecting Your Data and Creating a Chart

Before creating the chart, you need to select the data you want to visualize. In our case, that's the entire range of A1:D5.

How to Create a Pie Chart in Google Sheets: A Simple Step-by-Step Guide (With Example)"
How to Create a Pie Chart in Google Sheets: A Simple Step-by-Step Guide (With Example)"
How to Make a Treemap Chart in Google SHeets
How to Make a Treemap Chart in Google SHeets
How to make a graph or chart in Google Sheets
How to make a graph or chart in Google Sheets

Once you've selected your data, the next step is to create the chart. You can do this by clicking on the 'Insert' tab in the menu and then clicking on 'Chart'.

Choosing the Right Chart Type

After clicking on 'Chart', you'll see a sidebar pop up with various chart types. The type of chart you choose depends on the story you want to tell with your data. For our fruit data, a bar chart would work well as it can clearly show the quantities of each fruit.

an image of a table with the number of sales items in each month and months
an image of a table with the number of sales items in each month and months
Learn Google Sheets: Easy Start for Beginners! (YouTube Tutorial)
Learn Google Sheets: Easy Start for Beginners! (YouTube Tutorial)
How To Make a Pie Chart in Google Sheets (Step-by-Step)
How To Make a Pie Chart in Google Sheets (Step-by-Step)

Let's select 'Bar' from the options and see how our data transforms. Google Sheets automatically creates a chart based on the selected data and chart type. However, there's still some formatting to do.

Customizing Your Chart

On the right side of your screen, you'll see a 'Chart editor' panel. This panel allows you to customize your chart. For a cleaner look, let's relocate the legend by clicking on the three dots next to 'Legend' and choosing 'Right'.

If you want to add a title, click on 'Add a chart title' and type 'Fruit Inventory'. To format the axes, click on 'Customize' under 'Horizontal axis' and 'Vertical axis'. Here, you can change the number format, font size, and color. Remember to click 'Apply' each time you make a change.

How to create and customize charts in Google Sheets (Quick version)
How to create and customize charts in Google Sheets (Quick version)
How to Make a Gauge Chart in Google Sheets
How to Make a Gauge Chart in Google Sheets
How To Create Charts In Google Sheets?
How To Create Charts In Google Sheets?
How to Create Progress Bars in Google Sheets (Step-by-Step)
How to Create Progress Bars in Google Sheets (Step-by-Step)
How to Make a Basic Gantt Chart in Google Sheets
How to Make a Basic Gantt Chart in Google Sheets
How To Create A Circle Chart In Google Sheets
How To Create A Circle Chart In Google Sheets

Working with Multiple Series and Axes

Our current chart shows the quantities of each fruit on the same axis. Sometimes, you might want to compare different metrics. For instance, you might want to add a new series for 'Peaches' and compare it directly to our existing data.

To do this, simply enter the data for 'Peaches' in a new column. Then, click on the 'Series' dropdown in the 'Chart editor' panel. Here, you can add or remove series, change the aggregate function, or even switch row and column data.

Adding a Secondary Axis

If you want to compare two sets of data with different scales, you can add a secondary axis. Click on the three dots next to 'Series' and choose ' rapides commerciale 2nd y-axis'. Drag the 'Peaches' series to the new axis, and you're done.

How to Make a Bar Chart in Google Sheets
How to Make a Bar Chart in Google Sheets
the google spreadsheet dashboard is shown in this screenshot
the google spreadsheet dashboard is shown in this screenshot
How To Create Charts and Graphs in Excel
How To Create Charts and Graphs in Excel

Formatting the secondary axis is similar to the primary axis. Just click on 'Vertical axis' and choose the secondary axis in the dropdown.

Now that you've created and customized your chart, it's time to consider how to use it effectively. Consider your audience and the story you want to tell. A well-designed chart can simplify complex data and make it more engaging. Happy charting!