How to Create a Bar Graph in Excel: Step-by-Step Guide

Do you ever feel like you're drowning in data? It can be hard to make sense of numbers and figures when they're sprawled out in a massive spreadsheet. One way to make understanding data easier is to create a bar graph. Not only do they look visually appealing, but they also allow us to quickly and easily spot trends and patterns in the data. In this step-by-step guide, I'll show you how to create a bar graph in Excel. Let's dive in!

Step 1: Enter Your Data

The first step is to enter your data into Excel. For this example, let's say we're tracking monthly sales for our business. We'll enter the sales figures for January, February, March, April, May, and June in a column.

Step 2: Highlight Your Data

Next, highlight the data in the column by clicking and dragging your cursor over the numbers. You can also use the Ctrl+A shortcut to select all of the data.

Step 3: Insert Your Chart

With your data selected, click on the "Insert" tab at the top of the screen. Then, click on the "Column" button in the "Charts" section. From there, select the type of column graph you want to create. In this example, we'll choose the standard vertical bar graph.

Step 4: Customize Your Chart

Now that your chart has been created, you can customize it to your liking. You can edit the title, axis labels, and legend by clicking on the chart and using the "Chart Elements," "Chart Styles," and "Chart Filters" buttons that appear.

Step 5: Finalize Your Chart

Once you've made any necessary adjustments, you can finalize your chart by formatting it. Click on the "Format Chart Area" button, which appears when you click on the chart. From there, you can adjust the colors, borders, and overall style of your graph.

Tips for Creating a Great Bar Graph

Now that you know how to create a bar graph, here are some tips for making it great:
  • Choose the right type of graph for your data
  • Make sure the data is clear and easy to read
  • Use colors sparingly and effectively
  • Label your axes and title your graph
  • Keep it simple and avoid clutter


In conclusion, creating a bar graph in Excel can be a great way to make sense of your data. By following these simple steps, you can create a visually appealing and easy-to-understand graph in no time. So, the next time you're staring at a spreadsheet full of numbers, remember that a bar graph could be just what you need to make sense of it all.
By clicking “Accept”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.