How to Create a Bar Chart in Excel and Google Sheets

-

|

Introduction

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.

How to 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.

How to Create a Bar Chart in Excel

Here are the steps to create a bar chart in Excel with this data.

  • Highlight all the data you wish to use (including the headers).
How to Create a Bar Chart in Excel
  • Then click Insert tab..
How to Create a Bar Chart in Excel
  • When you click Insert tab, a drop-down with additional options will be displayed. Look for the Charts group (see the image below)…
How to Create a Bar Chart in Excel
  • 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.

How to 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.

How to Create a Bar Chart in Excel and Google Sheets

Here are the steps to create a bar chart in Google Sheets:

  • Highlight the whole data in Google Sheets (including the headers).
How to Create a bar Chart in Excel and Google Sheets
  • With the data highlighted, click Insert tab.
How to Create a Bar Chart in Excel and Google Sheets
  • 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…

Conclusion

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.

I hope you found this guide useful. If you have a question, comment or feedback use the “Leave a Reply” form found at the end of this page.

For more guides visit our Windows How To page.

  • Was this post Helpful?
  • YesNo

LEAVE A REPLY

Please enter your comment!
Please enter your name here

FEATURED POSTS

How to Embed YouTube Video on Facebook

How to Embed YouTube Video on Facebook

This Itechguide teaches you how to embed YouTube video on Facebook. There are 2 high-level steps discussed in this guide:
How to Cancel Amazon Music Unlimited

How to Cancel Amazon Music Unlimited (PC or Amazon Apps)

This Itechguide teaches you how to cancel Amazon music unlimited. It offers steps to cancel Amazon music unlimited from a PC, Amazon...
How to Change Default Font in Google Docs

How to Change Default Font in Google Docs

This Itechguide teaches you how to change default font in Google Docs. Here are the high-level steps to change default font in...
How to Print Google Slides with Notes

How to Print Google Slides with Notes

This Itechguide teaches you how to print Google Slides with notes.
How to Add Bullet Points in Google Slides

How to Add Bullet Points in Google Slides (Android or iOS Apps or PC)

This Itechguide teaches you how to add bullet points in Google Slides. The guide offers steps to add bullet points in Google...

ADVERTISEMENTS

TRENDING POSTS

Remote Desktop Connection

Remote Desktop Connection an Internal Error Has Occurred [Fixed]

Introduction I recently received the error message "Remote Desktop Connection an Internal Error Has Occurred". It was strange because...

Find My Samsung: Register and Use Samsung Find my Mobile

Introduction Ever wondered how you could find your Samsung phone if you lost it? Find my Samsung or Samsung...
What is the Difference Between PowerShell and CMD?

Windows Powershell vs CMD: Differences and Similarities

Introduction This short guide compares Windows PowerShell vs CMD (Windows command prompt). I will cover the history and nature...
Spotify No Longer Supports this Version of Microsoft Edge

Spotify No Longer Supports this Version of Microsoft Edge [Fixed]

Introduction When you open Spotify web player on Microsoft Edge, you may receive the error message "Spotify No Longer...
Windows 10 Won't Boot

Windows 10 Won’t Boot With Black Screen? 3 Ways to Fix It

Why Won't Windows 10 Boot Up? If your Windows 10 stops with a black screen, the first question in...

BEST OF ITECHGUIDES

windows 10 keeps going to sleep

What to Do If Windows 10 Keeps Going to Sleep

Introduction It can be frustrating if suddenly your Windows 10 keeps going to sleep. You have to log back...
Configure Map Network Drive with Group Policy

Map Network Drive in Windows 10 with Group Policy

Introduction This guide demos how to map network drive with group policy. This guide is...
How to Pin a Post on Facebook from Desktop or Mobile Phone

How to Pin a Post on Facebook from Desktop or Mobile Phone

This guide demos how to pin a post on Facebook. It offers steps to pin a post from a desktop or a...
0xc000021a: Status System Process Terminated Error [Fixed]

0xc000021a: Status System Process Terminated Error [Fixed]

Introduction You may receive "0xc000021a (STATUS_SYSTEM_PROCESS_TERMINATED)" error after installing a new device on your Windows computer. You may also...
server 2016 not downloading updates from wsus

Fix for Server 2016 not Downloading Updates from WSUS

Introduction If you experience Server 2016 not downloading updates from WSUS, it is likely caused by a known bug....

ADVERTISEMENTS

RECENT POSTS

How to Embed YouTube Video on Facebook

How to Embed YouTube Video on Facebook

This Itechguide teaches you how to embed YouTube video on Facebook. There are 2 high-level steps discussed in this guide:
How to Cancel Amazon Music Unlimited

How to Cancel Amazon Music Unlimited (PC or Amazon Apps)

This Itechguide teaches you how to cancel Amazon music unlimited. It offers steps to cancel Amazon music unlimited from a PC, Amazon...
How to Add to outline in google docs

How to Add to Outline in Google Docs

This Itechguide teaches you how to add to outline in Google Docs. The guide offers steps to add to outline in Google...
How to Go Frame by Frame in YouTube

How to Go Frame by Frame in YouTube

This Itechguide teaches you how to go frame by frame in YouTube. YouTube does not have an inbuilt tool that allows you...
How to Change Default Font in Google Docs

How to Change Default Font in Google Docs

This Itechguide teaches you how to change default font in Google Docs. Here are the high-level steps to change default font in...

MUST READ

How to Add Admin to Facebook Group

How to Add Admin to Facebook Group (From PC or Mobile App)

Introduction This guide demos how to add admin to Facebook group. After creating a Facebook group, you may need...
active Directory currently not available

The Active Directory Domain Services is Currently Unavailable [Fixed]

Introduction The error message "The Active Directory Domain Services is Currently Unavailable" could be received in any of the...
How to Set Google Chrome as Default Browser for Windows 10

How to Set Google Chrome as Default Browser for Windows 10

Introduction This guide demos how to set Chrome as default browser for Windows 10. Windows 10 sets Microsoft Edge...
How to Add to outline in google docs

How to Add to Outline in Google Docs

This Itechguide teaches you how to add to outline in Google Docs. The guide offers steps to add to outline in Google...

How to Fix “Your PC Ran into a Problem and Needs to Restart” in...

Introduction "Your PC Ran into a Problem and Needs to Restart" in Windows Server 2016 error may be caused...

LATEST DEALS

Exclusive Student Offer_Save 10% on selected Surface devices

By using this website you agree to accept our Privacy Policy and Terms & Conditions