How to Make a Graph in Looker

Creating graphs in Looker Studio (formerly Google Data Studio) is a straightforward way to turn your raw data into clear, easy-to-understand visuals. This process is essential for spotting trends, tracking performance, and telling a compelling story with your numbers. This guide will walk you through the entire process, from connecting a data source to choosing the right chart type and customizing its appearance on a dashboard.

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

Getting Started: Connecting Your Data

Before you can make a single graph, Looker Studio needs something to visualize. You have to start by connecting a data source. This is the raw material for all your charts, tables, and scorecards. It might be a simple Google Sheet where you track projects or a complex database like Google Analytics with all your website traffic.

Looker Studio supports a vast library of "connectors" that allow you to pull data directly from popular platforms. Some common ones include:

• Google Sheets
• Google Analytics
• Google Ads
• BigQuery
• File upload (e.g., CSV)
• YouTube Analytics

Let's walk through an example of connecting a Google Sheet, which is one of the simplest ways to start.

Step-by-Step: Connecting to Google Sheets

1. Log into Looker Studio and click the Create button in the top left, then select Data Source.
2. You'll see a gallery of connectors. Use the search bar or find Google Sheets and select it.
3. You may be asked to authorize Looker Studio to access your Google Sheets. Click Authorize.
4. Next, you'll see a list of all the spreadsheets in your Google account. Select the spreadsheet you want to use, then choose the specific worksheet (the tab) within that file.
5. Looker Studio gives you a few options. Make sure "Use first row as headers" and "Include hidden and filtered cells" are checked if they apply to your sheet.
6. Click the blue Connect button in the top right corner.

After you connect, you’ll see a schema view. This is Looker's interpretation of your data, breaking it into fields. Don't worry too much about this for now, but familiarize yourself with the two main types of fields: Dimensions (in green) and Metrics (in blue). Think of dimensions as the 'what' or 'who' (e.g., Country, Product Name, Date) and metrics as the 'how much' (e.g., Sales, Pageviews, Visitors). Getting this distinction right is the foundation of building any graph.

Your First Graph: Building a Simple Bar Chart

With your data source connected, you’re ready to build. We’ll start with a classic bar chart — one of the most common and useful visualizations for comparing categories.

1. If you aren't already in one, create a new report by clicking Create > Report from the Looker Studio home page.
2. Looker will immediately prompt you to add one of your data sources to the report. Find the Google Sheet you just connected and click Add. A default table will probably appear on your blank canvas - you can select it and press Delete to start fresh.
3. In the top toolbar, click Add a chart. A dropdown menu with all the chart types will appear.
4. Navigate to the Bar chart section and select the first option, a standard vertical bar chart.
5. Your cursor will turn into a crosshair. Click and drag on the canvas to draw a box where you want your graph to appear.

Once you place the chart, Looker will automatically populate it with some dimension and metric from your data source. It might not be what you want, but that's where the real work begins.

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

Configuring Dimensions and Metrics

Whenever you select a chart, a Properties Panel appears on the right side of the screen. This panel has two main tabs: Setup and Style. We'll start with Setup.

• Data source: This should already be set to your Google Sheet.
• Dimension: This field determines the labels for your bars. It’s what you are grouping your data by. Drag a categorical field from the "Available Fields" list on the right and drop it into the Dimension box. For example, if you're analyzing sales data, you might drag a field named "Product Category" here.
• Metric: This field determines the height of each bar. It's the numerical value you want to measure. Drag a numeric field, like "Revenue" or "Units Sold," into the Metric box.

As soon as you configure both fields, your bar chart will instantly update to show a meaningful visualization, like Revenue by Product Category. You just created your first graph!

Choosing the Right Chart for Your Data

A bar chart is versatile, but it's not always the best choice. The type of graph you use should depend on the story you are trying to tell with your data.

Bar/Column Charts

Use When: You want to compare numerical values across different distinct categories.

Example: Showing total sales for your top five performing countries. Each country is a category, and the bar height represents its sales volume. Horizontal bars are often better when you have long category names.

Line Charts

Use When: You need to visualize a trend over a continuous period of time.

Example: Tracking website traffic (sessions) daily over the past 30 days. The x-axis would be the date, and the y-axis would be the number of sessions, showing ebbs and flows in user activity.

Pie/Donut Charts

Use When: You want to show the composition of a single total value — how different parts make up a whole.

Example: Displaying the percentage of website traffic from different device types (Desktop, Mobile, Tablet). This quickly shows which device drives the most visitors. A word of caution: pie charts become unreadable with more than 5-6 categories.

Scorecards

Use When: You need to highlight a single, important key performance indicator (KPI).

Example: A large scorecard at the top of your dashboard showing total company revenue for the quarter. You can add a comparison to a previous period to add context (e.g., "+5% vs. last quarter").

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

Tables

Use When: You need to show detailed, row-level data. Tables aren't great for spotting high-level trends quickly, but they're unbeatable for providing granular information.

Example: Listing every single sale with details like Customer ID, Product Sold, Date, and Price.

Customization and Styling: Making Your Graph On-Brand

A functional graph is good, but a well-styled graph is great. Visual polish helps your audience understand the information faster and keeps your dashboard looking professional. All this happens in the Style tab of the Properties Panel.

Here are a few key styling options to transform your basic graph:

Colors

Don't stick with the default blue. You can set a single color for all bars or use the "Color by" feature to automatically assign different colors based on your dimension. Use your company's brand colors to make the dashboard feel like a cohesive part of your reporting.

Labels and Legends

If you have multiple metrics or dimensions, a legend helps users differentiate them. You can change its position (top, bottom, right) or text style. Also, consider adding Data Labels directly onto your chart's bars or points. This prints the exact value on the graph, so your audience doesn't have to guess by looking at the axis.

Axes and Gridlines

Make your graph cleaner by adjusting its axes and grid. You can:

• Change the titles of the X and Y axes for clarity.
• Adjust font size and color for better readability.
• Set a custom range for an axis (e.g., force the Y-axis to start at zero).
• Make gridlines more subtle by changing their color to a light gray, or remove them entirely for a minimalist look.

Background and Border

Give your charts a professional touch by adding a subtle background color or a border with rounded corners. This can help visually separate it from other elements on a crowded dashboard.

Practical Tip: Less is almost always more. A clean, uncluttered graph with a clear takeaway is more effective than one loaded with colors, labels, and borders. Start simple and only add elements that genuinely improve clarity.

Pro Tips & Common Pitfalls

As you get more comfortable, you can start using some of Looker Studio's more advanced features and learn to avoid common mistakes.

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

Pro Tip: Use Filters to Drill Down

A static chart is useful, but an interactive one is even better. Use the Add a control feature in the top toolbar to add filter dropdowns, search boxes, or date range selectors. By linking these to your graphs, your team can explore the data themselves — for example, filtering the entire dashboard to show data for just one specific marketing campaign or region.

Pro Tip: Use the Correct Data Types

Sometimes Looker misinterprets a column. It might see a column of dates as text, or a numerical ID as a metric it should sum up. If a graph is behaving strangely, go back to your data source's schema page. There, you can click on any field’s data type and manually change it (e.g., change Text to Date or Number to Text).

Common Pitfall: Misleading Visualizations

Always present your data honestly. One classic mistake is changing the baseline of a bar chart's Y-axis. Unless you have a very specific reason, an axis showing quantities should always start at zero. Starting it higher can dramatically exaggerate small differences and mislead your audience. Always ask yourself if your graph accurately represents reality.

Final Thoughts

By connecting a data source, choosing an appropriate chart, configuring its dimensions and metrics, and applying thoughtful styling, you can transform complex spreadsheets into clear, actionable insights in Looker Studio. This process is about more than just making data look pretty, it's about making it understandable so you can make smarter decisions.

Building reports yourself is a powerful skill, but anyone who's made dashboards knows the process of connecting data, designing layouts, and wrestling with settings takes time. At Graphed, we help you skip the manual setup entirely. You can simply connect your sources and ask our AI to create dashboards using conversational language, like "Show me Q4 sales by region." Go from a simple question to an interactive, real-time dashboard in seconds, letting you focus on the insights, not the setup.