Looker Studio Tutorial #10 — How to Build and Style Bar Charts

I walk you through how I build bar charts in Looker Studio for marketing dashboards and why I choose certain settings over others. This is a practical, step-by-step guide that covers metric selection, dimensions, drill downs, styling choices, and a few troubleshooting tips I learned the hard way.

If you want the full walkthrough on screen, you can view the tutorial here:

Step 1: Choose Users or Sessions — pick the right metric for acquisition

The first decision I make is whether to use sessions or users for acquisition metrics. Historically, dashboards focused on sessions, but I prefer user acquisition now. Users reflect unique people, while sessions reflect individual visits. If the same person visits your site three times in a day, that counts as three sessions but one user.

For most marketing dashboards I build, users provide a clearer picture of reach and audience size. Use sessions when you care about visit-level behavior, and users when you care about the number of distinct people reached.

Step 2: Add the bar chart and set dimension and metric

From the Add Chart menu choose a bar chart. Looker Studio offers vertical, horizontal, stacked and 100% stacked variants. I typically start with a vertical or horizontal bar chart and then adjust orientation based on label length and readability.

Important setup rules:

• Assign a dimension (for example, First user default channel group).
• Assign a single primary metric (for example, Users or Active users).
• When you add only one metric you can use a breakdown dimension. If you add two or more metrics you cannot use breakdowns.

Choosing channel as a dimension is common. Channel groups are logical aggregates of source, medium, and campaign parameters. If you plan to drill down, set the drill-down order to medium then source so the user can move from channel to medium to the exact source.

Step 3: Configure drill downs, breakdowns and optional metrics

Drill downs let stakeholders dig into the data without switching views. For channel-based charts I set drill down to First user medium then First user source. For date-based charts I use Year > Month > Week. Keep drill down logical and consistent across charts.

Breakdowns are useful when comparing subgroups within the same metric. For example, add a breakdown by new vs returning to show how much of each channel’s users are returning visitors.

Optional metrics let viewers toggle additional KPIs on the same chart. I often include New users and Total users as optional metrics so stakeholders can switch context without creating separate charts.

Step 4: Style decisions — orientation, labels, legend and colors

Style is not decoration — it influences readability. Here is how I decide:

1. Orientation: Use vertical bars when labels are short and you want a compact look. Use horizontal bars when labels are long. Horizontal bars make it easier to read channel names and compare values side by side.
2. Number of bars: Limit bars to about 5 to 10. Above 10 the chart becomes hard to scan. If you must show many categories, use a table instead.
3. Data labels: Show labels when the chart has a few bars. Hide them when there are many bars to avoid clutter. Use the compact number format to keep labels tidy.
4. Legend: Remove the legend when only one metric is present. It saves space. Bring it back when multiple metrics or breakdowns require clarification.
5. Colors: Stick to one primary color from your theme palette for simplicity. Use color to highlight a single bar if you need attention on a channel.
6. Axes: Keep axis titles concise and align both axes to zero if the chart uses dual axes. This avoids misleading slopes.

I also place the chart header in a way that doesn’t steal vertical space. Top headers work well in small layouts; center or bottom headers often eat usable area on narrow dashboards.

Step 5: Interactions, sorting and filters

Turn on cross-filtering when charts should drive the whole page. Sorting by your primary metric (for example, Users) helps viewers instantly see the top channels. Add date range controls and filters to provide context and allow quick segmentation.

If a chart uses drill down plus optional metrics, test the interaction in view mode to confirm the drill-down works as expected. I always test charts before sharing dashboards with clients because certain connector combinations can behave unpredictably.

Step 6: Troubleshooting connector issues and data mismatches

Connectors sometimes hiccup. I ran into a situation where medium and source did not appear to work together and the chart refused to drill down. My steps to diagnose:

• Try the same combination in a simple table to confirm the data exists.
• Refresh the data in the report. API rate limits or demo accounts can cause incomplete responses.
• If the default GA4 connector misbehaves, reconnect using your own account or try an alternative connector (for example, a third-party source connector).

These checks usually reveal whether the problem is a connector, a temporary API limit, or a field mismatch (session-level versus user-level dimensions). When I find issues I document them on the dashboard or in an accompanying notes section so stakeholders understand data caveats.

Final checks and presentation tips

Before handing over a dashboard I perform a short checklist:

• Confirm drill downs and optional metrics work in view mode.
• Verify sorting and date range controls behave correctly.
• Check that labels, colors and legend provide a clear, simple message.
• Run a quick data validation against GA4 or source tables for a few sample points.

Small adjustments in style and layout make the dashboard feel professional. Less is more: I remove unnecessary chart decorations and keep only the controls that provide value.

Tools I Use

Windsor.ai — the simplest way to connect GA4, Google Ads, Facebook Ads, and more to Looker Studio.
Use promo code gaillereports for 10% off any plan
Supermetrics — a reliable connector for teams and agencies working with multiple data sources:

If you work with Meta Ads or want a connector comparison, read this:
Top Facebook Ads Connectors for Looker Studio — How to Choose the Right One

More Articles You Might Like

• How to Set Theme and Layout in Looker Studio and Connect Your GA4 Data
• How to Make Your Looker Studio Dashboard Look Professional (Header Setup Guide
• Looker Studio Report Tutorial #5 — Add Scorecards with KPIs (Setup, Styling & Metrics Explained)
• Build Professional Tables in Looker Studio — Setup, Styling & Best Practices
• How to Visualize Data Over Time in Looker Studio Reports (Time Series Tutorial #6)

---

Summary

Bar charts are one of the most flexible visuals in Looker Studio. They work well for comparisons, channel performance, and simple breakdowns — as long as you choose the right metric, dimension, and drill-down structure. Keep styling minimal, test interactions in view mode, and use horizontal orientation when labels get long.

Small layout choices make a big difference: consistent spacing, limited categories, clean colors, and clear labels create charts that people actually understand. With this setup, your bar charts will stay readable, lightweight, and ready for exploration.