How to Make a Column Chart in Google Sheets

In this article, you will learn how to make a bar chart in Googles Sheets. 

‍

How to create a column chart in Google Sheets

1. Select a series of data you want to visualize.
2. Go to “Insert” and click ”Chart”.
3. Then, you have a default chart on a sheet, and a chart editor shows up on the right.
4. Select “Column chart” in Chart type section.
5. Confirm the data range selected and adjust it if needed.
6. Also, ensure the correct ranges are input in X-axis and Series sections.
7. Move to the “Customize” tab in the chart editor and customize your chart if you want.

‍

See how to customize your chart with an example. Assume you are a finance manager and want to visualize your company's historical and estimated revenue performance in 2022 according to the company brand fonts and colors. You want to make the following changes to the basic chart you have just created:

1. Change the font style to “Roboto”
2. Revise the title to “Revenue Performance in 2022”. It should be bold and colored in blue, and its font size is 24
3. Change the color of the bars to the same blue as the title
4. Show a vertical axis and modify its maximum value to 1,200
5. Remove gridlines in the background of the chart
6. Add data labels

‍

Font style change

Go to “Chart style” in the “Customize” tab. Select “Roboto” from the drop-down list at “Font”.

‍

Revision of the title

Go to “Chart & axis titles” in the “Customize” tab. Select “Chart title”, enter the title in the text box, change font style and color, make it bold, and change text color.

‍

‍Change of bars’ color

Go to “Series” in the “Customize” tab. Select “Fill color” in the “Format” section; choose the color you want to fill in.

‍

Adjustment of the vertical axis

Go to “Vertical axis” in the “Customize” tab. Check “Show axis line” (if unchecked as a default setting), and input specific values for the minimum and maximum of the vertical axis range.

‍

Removal of the gridlines

Go to “Gridlines and ticks” in the “Customize” tab. Uncheck “Major gridlines” (if checked as a default setting).

‍

Adding data labels

Go to “Series” in the “Customize” tab. Check “Data label” at the bottom of the menu. Change “Position” from “Auto” to “Outside end”.

‍

‍

How do I make a stacked column chart in Google Sheets?

Check this article to learn how to create a stacked column chart.

‍

How do I plot two columns in sheets?

Check this article to learn how to create a scatter chart.

‍

Analyze your live financial data in a snap

Are you learning this tip to visualize financial data, build a financial model, or conduct financial analysis? If so, LiveFlow may help you to automate manual workflows and keep numbers updated in real time. For instance, you can easily track and update your last twelve months’ results by using Trailing 12 Months Profit and Loss Excel and Google Sheet Template and Consolidated Trailing 12 Months P&L | Excel & Google Sheet Template. Furthermore, you can access more than fifty templates here, from the simple Income Statement and Operational KPI templates to Multi-Currency Consolidated Income Statement, Balance Sheet, and Cash Flow templates. You can also customize these templates as you want without breaking the automated data inflow.

‍

To learn more about LiveFlow, book a demo.