How to Create a Column Chart in Google Sheets

Google Sheets has a variety of charts and graphs ready for you to use. These charts help you visualize your data and also help you understand and present your findings better.

One of the most common chart types is the column chart, where different categories are represented as rectangular columns in the chart. Column charts are often used to represent and compare groups of data.

Although Google Sheets automatically predicts your intent and chooses a chart type for your data, its prediction is prone to error. Read on to know about the column chart and how to make it.

What is a column chart?

A column chart, often referred to as a bar chart, shows values ​​as rectangular columns or bars. A column chart is best used to display and compare values ​​from different ranges. For example, if your university has a number of members of different clubs, you might best represent this with a column chart.

Of course, there is no obligation on which chart to use for a given set of data, but using the right chart for your data makes interpretation and analysis easier for both you and your audience.

You can also use a column chart to show changes in a single or multiple series over a period of time. However, line charts are preferred for that context.

makeup video of the day

Google Sheets has a way with charts where it automatically decides which chart type is best suited to display the data you choose. While Google Sheets is often correct in this decision, you can change the chart type at any time from the chart settings.

RELATED: How to Create a Line Graph in Google Sheets

How to Create a Column Chart in Google Sheets

A column chart in Sheets.

In this example, we have a count of SUV cars from rental service. The goal is to create a column chart to display the number of cars.

  1. Select both columns.
  2. go for insert, and then click Chart, Sheets will automatically create a chart. In our case, it was a pie chart. We want a column chart, so we’ll change the type of chart.
  3. go for chart editor and then click Set-up tab.
  4. change chart type To column chart, You now have a column chart!

RELATED: How to Create a Graph or Chart in Excel

How to Customize a Column Chart in Google Sheets

A customized column chart in Sheets.

Once you have created your column chart, you can continue on and customize it. You can add 3D effects to it, change colors and even add a trendline.

Change the color, font, and style of the chart

You can change the background color and font from the chart style in the chart editor.

  1. Double-click the chart to bring up the chart editor.
  2. go to Customize tab and then open chart style, Here you can change the font, border and background color.
  3. Control 3D Settings to give your column a 3D appearance.
  4. Control Maximum Option to set the maximum value for the chart as the maximum.
  5. Check Compare Mode To enable the tooltip that appears when you hover over a data point on the chart.

Change column color and style

Changing the background color does not affect the columns. You can change the color of the column from the series settings.

  1. Double-click on the chart to go to chart editor,
  2. go to Customize tab.
  3. go to Chain section. You can change the color and style of your column here.

add a trendline

A trendline helps you identify the trend in your chart, and helps you see where it is headed. You can add a trendline to your chart and customize it by checking a simple setting.

  1. Double-click on the chart and go to chart editor,
  2. In Customize tab, go to Chain,
  3. Control trendline Installation.
  4. Customize the trendline to your liking.

Adding Gridlines and Ticks

Gridlines divide the chart into smaller units and make the chart easier to understand for you and your audience.

  1. Double-click on the chart to go to chart editor,
  2. In Customize tab, scroll to the bottom Gridlines and Ticks,
  3. Select the axis where you want to add gridlines or ticks. Since the numbers in this chart are on a vertical axis, gridlines are only available on that axis. You can add ticks only on the horizontal axis.
  4. Check minor gridlines to enable them. You can then change the vacancy type and count.
  5. Check minor ticks or key tick to enable them. Tick ​​and gridlines follow the same settings for spacing and count.

visualize your goals

Column charts are handy visualizations that let you compare different categories. Now you know how to make one and customize its color, font, style, and even add a trendline to it.

Graphs are at their full potential when used for the right context, so make sure you choose the right chart type before creating one.

excel charts and graphs
8 Types of Excel Charts and Graphs and When to Use Them

Graphics are easier to understand than text and numbers. Charts are a great way to visualize numbers. We show you how to create charts in Microsoft Excel and which ones are best used.

Read further

About the Author


Get the best of Newspaper delivered to your inbox daily

Most Viewed

Related Stories