In this article, you will learn how to make a bar chart in Googles Sheets.
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:
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”.
Check this article: How to Make a Stacked Column Chart in Google Sheets to learn how to create a stacked column chart.
It is easy. After inserting a graph, select another chart pattern in the “Chart” type section. You can learn how to create other basic charts in the following articles.
How to Create a Pie Chart in Google Sheets
How to Make a Waterfall Chart in Google Sheets
How to Make a Line Chart in Google Sheets
How to Make a Stacked Column Chart in Google Sheets
How to Make a Bubble Chart in Google Sheets
Are you interested in creating a customized KPI dashboard reflecting your data in real time? Check LiveFlow and the following template with graphs.
Here is an example of how charts are utilized for data sharing and reporting.
You can learn about other Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides
Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows and update numbers in real-time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. You can also customize these templates as you want without breaking the automated data inflow.
To learn more about LiveFlow, book a demo.
Learn how to do this step-by-step in the video below 👇