How to Make a Bar Graph

Creating a bar graph is one of the quickest ways to visually compare different categories of data. Whether you're tracking sales figures, website traffic sources, or survey responses, a well-made bar graph makes your numbers easy to understand at a glance. This guide will walk you through exactly how to create clear and effective bar graphs using the tools you probably already use, like Excel and Google Sheets.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Exactly Is a Bar Graph?

A bar graph (or bar chart) is a straightforward visualization that uses rectangular bars to represent different data values. The length of each bar is proportional to the value it represents, making it incredibly easy to see which category is largest, which is smallest, and how they all stack up against each other.

You'll typically work with two axes:

• The category axis (usually the horizontal x-axis) lists the distinct categories you are comparing, like "Social Media," "Organic Search," or "Product A."
• The value axis (usually the vertical y-axis) displays the numerical scale for your data, such as visitor counts, revenue, or units sold.

While the classic format is a vertical column chart, you can also use a horizontal bar chart, which is especially useful when you have long category labels that are difficult to fit on the x-axis.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

When to Use a Bar Graph

Bar graphs are your go-to visualization for comparison. Here are some of the most common scenarios where a bar graph is the perfect choice:

• Comparing Categories: The most classic use case. For example, comparing the performance of different marketing channels (Organic vs. Paid vs. Social) or sales across different regions (North America vs. Europe vs. Asia).
• Ranking Data: They are perfect for showing rankings, like your top 10 best-selling products or the most engaged countries on your website.
• Showing Parts of a Whole: Using a stacked or grouped bar chart, you can break down categories into sub-categories. For instance, you could show total sales per quarter (the Total bar) and have it stacked with segments for "New Business" and "Renewals" within that same bar.

First, Organize Your Data

Before you can build a graph, you need clean, well-organized data. A beautiful chart can't save messy or inaccurate information. The best way to set up your data for a bar graph is in a simple two-column table.

One column should contain your categories (the labels), and the adjacent column should contain the corresponding numerical values.

Let's use an example. Imagine you want to visualize your website's traffic sources for the last month. Your data might look like this:

This simple format is universally recognized by spreadsheet software and data visualization tools, making the chart creation process smooth and error-free.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

How to Make a Bar Graph in Excel

Microsoft Excel is a powerhouse for data analysis and is one of the most common tools for creating charts. Here’s how to do it step-by-step.

1. Enter Your Data: Type your categories and values into two separate columns, just like the example above.
2. Select Your Data: Click and drag your cursor to highlight all the cells containing your data, including the headers ("Source" and "Visitors").
3. Navigate to the Insert Tab: At the top of the Excel window, click on the "Insert" tab in the main ribbon menu.
4. Choose Your Chart: In the "Charts" section, you’ll see an icon that looks like a small bar chart, labeled "Insert Column or Bar Chart." Click on it.
5. Pick a Chart Sub-Type: A dropdown menu will appear with several options like 2-D Column, 3-D Column, 2-D Bar, etc. For clarity, a "2-D Clustered Column" (the standard vertical bar chart) is usually the best choice. Select it.

Excel will instantly generate the bar graph and place it on your worksheet. From here, you can customize it by clicking on the chart and using the "Chart Design" and "Format" tabs that appear at the top. You can give your chart a title, label your axes, and change the bar colors to match your brand.

How to Make a Bar Graph in Google Sheets

If you work collaboratively or prefer cloud-based tools, Google Sheets makes creating bar graphs just as easy as Excel. The process is very similar.

1. Enter Your Data: Add your categories and values into two columns on a new sheet.
2. Select the Data Range: Highlight the cells you wish to include in your chart.
3. Insert the Chart: Go to the main menu and click "Insert" and then select "Chart" from the dropdown list.
4. Choose the Chart Type: Google Sheets is pretty smart and will often correctly guess that you want a bar graph. If it picks another type, or if you want to change it, a "Chart editor" sidebar will appear on the right. Under the "Setup" tab, click the "Chart type" dropdown and select either "Column chart" (vertical) or "Bar chart" (horizontal).
5. Customize Your Graph: In the same "Chart editor" sidebar, click on the "Customize" tab. Here you can tweak everything from the chart title and axis labels to the gridlines and bar colors.

Your graph will update in real-time as you make changes. Once you're happy, you can copy the chart and paste it into a Google Doc, a slide deck, or download it as an image.

How to Make a Bar Graph in Canva

Sometimes you need a bar graph for a marketing report, social media graphic, or presentation. Canva is an excellent tool for creating beautifully designed charts that align with your branding.

1. Start a New Design: Open an existing Canva design or create a new one.
2. Find the Chart Element: In the editor's left-side panel, click on "Elements." In the search bar, type "chart" and hit enter. Select the bar chart option that suits your needs.
3. Add Your Data: A placeholder bar chart will appear on your canvas. When you click it, a table will appear in the left-side panel. You can either manually type your data into this table or, more easily, copy your two-column data from Excel or Google Sheets and paste it directly into Canva's table. The chart will update automatically.
4. Customize the Appearance: Click on the chart or individual bars to change colors. You can select colors from your brand kit or use the color picker. Use the main toolbar at the top of the editor to adjust fonts, text size, and spacing to perfect the design.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Best Practices for Clear and Honest Bar Graphs

Creating a chart is easy, but creating an effective one requires a bit of thought. Follow these tips to make sure your bar graphs are clear, honest, and impactful.

• Start Your Value Axis at Zero: This is the golden rule. Starting the value (y-axis) scale at a number other than zero can dramatically distort the perceived differences between bars, making small variations look like massive gaps. It's a common way to mislead with data, so always keep your baseline at zero.
• Order Your Data Logically: Unless your categories have a natural chronological order (like months of the year), it’s best to sort your bars. Arrange them in ascending or descending order of value. This makes it much easier for your audience to quickly grasp rankings and comparisons.
• Use Clean and Direct Labels: Give your chart a clear, descriptive title. Label your x-axis and y-axis so there is no confusion about what is being measured. If the exact values are important, consider adding data labels directly on top of or just inside the end of each bar.
• Keep Colors Purposeful: Don't throw a rainbow of colors at your chart just to make it "pop." Use a simple, clean color palette. If you want to draw attention to a specific category, make that bar a contrasting color while keeping the others neutral.
• Avoid Clutter: Simplicity is key. Remove distracting elements like excessive gridlines, shadows, or 3D effects. A clean, 2-D chart allows the data to be the star of the show.

Final Thoughts

A bar graph remains one of the most effective and widely understood ways to present data. Now you know how to build one from scratch using foundational tools like Excel, Google Sheets, and Canva. By following the best practices, you can create professional visualizations that clearly communicate your insights and tell a story with your data.

Of course, building a chart once is one thing, keeping it updated across all your platforms is another. We've spent countless hours manually pulling reports from Google Analytics, ads platforms, and our CRM, just to stick the data into a spreadsheet to create these bar graphs. That's why we built Graphed. It connects directly to your data sources and automates the entire process. You can just ask for "a bar chart showing revenue from Facebook campaigns last month," and it builds a live, interactive chart instantly, eliminating all the manual exporting and formatting.