Quick wins for a faster PC:
Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Repair Windows errors before they cause bigger problemsFix Now →Scan for outdated or missing drivers - takes under a minuteDriver Scan →iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
This guide demos how to create a bar chart in Excel and Google Sheets. A bar chart is used to visually compare values across categories.
Representing data in charts makes it easier to understand trends and make important business decisions.
Option 1: Create a Bar Chart in Excel
To create a bar chart in Excel you need a set of data. I will use the data in the Excel sheet below for my demo in this guide.
Do these 3 things before closing this tab:
1Repair Windows errors before they cause bigger problems2Fix the driver behind crashes, sound loss and screen glitches3Clear out junk files and repair common Windows errorsHere are the steps to create a bar chart in Excel with this data.
Popular on Amazon
- Highlight all the data you wish to use (including the headers).
- Then click Insert tab..
- When you click Insert tab, a drop-down with additional options will be displayed. Look for the Charts group (see the image below)…
- Then, within the Charts group, click the bar chart icon (highlight in the image below – the smaller box).
- Finally, click on the bar chart type you wish to use. When you click on a bar chart type, Excel will display the chart beneath.
- Move the bar chart away from your raw data.
Option 2: Create a Bar Chart in Google Sheets
The Google Sheets in the image below contains the data I will use for the demo in this guide.
Here are the steps to create a bar chart in Google Sheets:
Also popular on Amazon
- Highlight the whole data in Google Sheets (including the headers).
- With the data highlighted, click Insert tab.
- Then click Charts.
- By default Google Sheets will insert a Line chart. To change the chart type, click the drop-down beside Line chart. Then scroll down and click on one of the Bar charts.
- To close the chart insertion tool, click the x sign.
- Then drag the bar chart away from your raw data…
I mentioned at the beginning of this guide that a chart makes it easier to understand trends and make better business decisions.
From the bar chart above, you can make a visual comparison of all the sales data.
Also popular on Amazon
- The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
- ABIS BOOK
I hope you found this article helpful. If you did, click on “Yes” beside the “Was this page helpful” question below.
You may also express your thoughts and opinions by using the “Leave a Comment” form at the bottom of this page.
Also popular on Amazon
For more guides visit our Microsoft Office How-to page.
Free tools Windows power users keep installed
One-click scans. No signup required.
Quick Recap
Also popular on Amazon
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.
