How to Make a Bar Graph in Google Analytics
Making a bar graph with your Google Analytics data is a great way to quickly see which marketing channels bring the most traffic or which countries your customers are coming from. This article will show you how to create these helpful visuals, both directly within Google Analytics 4 for quick analysis and using external tools for creating more permanent, shareable dashboards.
Why Bar Graphs are Perfect for Website Analytics
Before jumping into the "how," let's quickly cover the "why." Bar graphs are one of the most effective ways to visualize website data because they are incredibly easy to understand at a glance. They excel at comparing different categories of data.
For example, you can use a bar graph to instantly compare:
- The number of sessions driven by different traffic sources (like Organic Search, Direct, and Social).
- Total users acquired from different countries or cities.
- Revenue generated by various product categories on an e-commerce site.
- Conversions from different marketing campaigns.
This simple format makes it easy to spot your top performers and areas that might need more attention without having to parse through rows and rows of numbers in a table.
How to Create a Bar Graph Directly in Google Analytics 4
Google Analytics 4 offers a powerful reporting suite called "Explorations" where you can build custom reports and visualizations, including bar graphs. This method is ideal for ad-hoc analysis when you want to answer a specific question quickly without leaving the GA4 interface.
Here’s the step-by-step process:
Step 1: Navigate to the Explore Tab
In the left-hand navigation menu of your GA4 property, click on the Explore icon. This is your canvas for creating custom reports that go beyond the standard ones GA4 provides.
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.
Step 2: Start a New "Blank" Exploration
You'll see a gallery of templates like "Funnel exploration" and "Path exploration." To build a simple bar graph from scratch, click on the large plus sign labeled Blank. This gives you a clean slate to work with.
Step 3: Add Your Dimensions and Metrics
This is the most important step. On the left side, you'll see a panel called "Variables." This is where you tell GA4 what data to pull. You need to define two things:
- Dimensions: These are the things you want to measure - the categories or labels for your bars. Think of them as the "what" or "who." Examples include Session default channel group, Country, or Page path.
- Metrics: These are the numbers you want to count - the height of your bars. Think of them as the "how many." Examples include Sessions, Total users, or Conversions.
Let's create a bar graph showing new users by what device they used. In the "Variables" panel:
- Click the plus sign (+) next to "Dimensions."
- In the search box, type "Device category" and check the box next to it. Click Import.
- Click the plus sign (+) next to "Metrics."
- In the search box, type "New users" and check the box. Click Import.
Your chosen dimensions and metrics will now appear in the Variables panel, ready to be used.
Step 4: Build Your Visualization
Now, look at the second panel, "Tab Settings." This is where you'll drag and drop your variables to build the graph.
- From the "Variables" panel, drag your dimension (Device Category) and drop it into the Rows or Breakdowns box under "Tab Settings."
- Next, drag your metric (New users) and drop it into the Values box.
As soon as you do this, a table will automatically appear on the right, showing your data. You're almost there!
Step 5: Change the Visualization to a Bar Chart
Above the table you just created, you'll see a set of small icons. By default, the table icon is selected. Click the icon that looks like a vertical bar chart (it's usually the second option).
Instantly, your data table will transform into a clean bar graph, visually representing your new users by device category (Desktop, Mobile, and Tablet).
Building More Powerful Bar Graphs Outside of GA4
The Explorations tool in GA4 is fantastic for quick dives into your data, but it has some limitations. Exploration reports can expire, they aren't meant to be permanent dashboard widgets, and their sharing capabilities are limited. For reports you need to check regularly, share with your team, or customize heavily, it's often better to use an external tool.
Method 1: Using Looker Studio (Formerly Google Data Studio)
Looker Studio is Google's free data visualization tool, and it connects flawlessly with Google Analytics. It's the perfect choice for building professional, interactive, and shareable dashboards.
Follow these steps:
Step 1: Start a New Report and Connect Your Data
Go to lookerstudio.google.com and click Blank Report. You’ll be prompted to add data. In the connectors list, select Google Analytics. You'll need to authorize your Google account, then select the GA4 Account and Property you want to pull data from. Click Add.
Step 2: Add a Bar Chart to Your Canvas
Once your data source is connected, you'll see a blank canvas. In the top menu, go to Add a chart and select one of the Bar Chart options (standard, stacked, etc.). Click anywhere on the canvas to place your chart.
Step 3: Configure Your Chart's Data
With the new bar chart selected, a "Properties" panel will appear on the right. This is where you'll connect your data, just like in GA4 Explorations.
- Under the "Data" tab, find the Dimension field and select what you want to compare. For example, search for and select Session default channel group.
- Find the Metric field and select the number you want to measure, such as Sessions.
Your bar chart will populate automatically, showing session counts for each marketing channel.
Step 4: Customize the Style
The real power of Looker Studio comes from its customization options. Click the Style tab in the properties panel to change colors, add data labels, adjust fonts, change the grid, and so much more, giving you full control over the look and feel of your graph.
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.
Method 2: The Quick Google Sheets Method
If you just need a simple, no-fuss chart for a static report or presentation and prefer spreadsheets, this is an excellent method. You can export data directly from a GA4 report (standard or exploration) and build a chart right in Google Sheets.
Step 1: Export Your Data from GA4
In GA4, go to the report containing the data you need (e.g., Reports > Acquisition > Traffic acquisition). In the top right corner of the report, you'll see a "Share this report" icon. Click it, then choose Download File > Download CSV.
Step 2: Import into Google Sheets
Open a new Google Sheet. Go to File > Import > Upload and select the CSV file you just downloaded.
Step 3: Create the Chart
Once your data is in the sheet, highlight the two columns you want to visualize (e.g., the column with channel names and the column with session counts). Then, go to the menu and select Insert > Chart.
Google Sheets is smart and will likely automatically create a bar chart for you. If it doesn't, you can easily change the chart type in the "Chart editor" panel that appears on the right.
Final Thoughts
In summary, creating a bar graph with your Google Analytics data is a straightforward process whether you need a quick answer or a permanent dashboard. Use GA4's Explore tab for fast, one-off analysis, and turn to tools like Looker Studio or Google Sheets when you need more durable, customized, and shareable visualizations for your team.
We know that even with these great tools, reporting can still be a tedious, manual process. That's why we built Graphed. Instead of clicking and dragging dimensions and metrics, you can simply ask in plain English, "Create a bar graph showing sessions by channel group for the last 30 days," and an interactive chart is instantly created for you. It streamlines the entire reporting workflow so you can spend less time building charts and more time acting on the insights they provide.
Related Articles
How to Create Facebook Ads API for Claude Code
Create a Meta Marketing API access token that never expires, using a system user, so Claude Code can pull Facebook ad reports and manage campaigns.
ClickHouse vs Postgres: When to Switch to Columnar
Comparing ClickHouse vs PostgreSQL means matching storage architecture to workload. Row storage wins for transactions. Columnar wins for scan-heavy analytics.
Google Ads for Orthodontists: Get More Booked Consults
Most orthodontic Google Ads campaigns waste money on low-intent searches. The problem is structure, not the platform.