How to Make a Column Chart in Looker with AI

Creating a column chart in Looker is a fundamental skill for visualizing your data, but now you can do it without clicking a single configuration menu. Thanks to AI, a simple sentence can generate the report you need in seconds. This article will walk you through exactly how to create a column chart using Looker's AI features, as well as the classic manual approach for more fine-grained control.

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 is a Column Chart and When Should You Use It?

Before building one, it's helpful to know why you'd choose a column chart in the first place. Column charts, sometimes called vertical bar charts, use rectangular columns of varying heights to represent different data values. They are one of the most common and easily understood chart types for a few key reasons.

Use a column chart when you want to:

• Compare different categories. This is their primary superpower. Column charts are perfect for comparing distinct items, like sales figures across different product lines, website traffic from various marketing channels, or the number of new customers acquired per quarter.
• Show values over a small number of time periods. While line charts are generally better for showing trends over time, column charts work well for comparing a few periods, like month-over-month revenue or quarterly performance. If you have more than 7-10 time periods, a line chart is usually a better choice.
• Display negative values. Because columns are anchored to a zero baseline, they can extend downwards to clearly represent negative numbers, which can be useful for showing profit and loss.

Column Chart vs. Bar Chart: What's the Difference?

A frequent point of confusion is the difference between a column chart and a bar chart. They are functionally identical but have one key difference: orientation.

• Column charts have vertical bars. They are best for when you have a smaller number of categories.
• Bar charts have horizontal bars. They are a much better option when you have long category names that would be difficult to read if scrunched up on a vertical axis.

A good rule of thumb: if your labels are too long to fit comfortably under the columns, you should probably use a bar chart instead.

Using AI to Create Your Column Chart in Looker

The latest versions of Looker include AI-powered features that let you build visualizations using natural language. This is a game-changer because you no longer need to know which fields are "dimensions" or "measures," you just need to know what question you want to answer. Think of it as having a conversation with your data.

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

Step 1: Start an "Ask Looker" Session

Instead of starting from a traditional Explore, you can now launch a conversational session with your data. Inside Looker, look for the option to "Ask Looker." This effectively opens a chat-like interface where you can type your request directly.

Step 2: Tell the AI What You Want to See

This is where the magic happens. Describe the chart you want to build in plain English. The more specific you are, the better the result will be, but even simple prompts can get you started. Focus on three main things: the chart type, what you're measuring (the metric), and how you want to group it (the dimension).

Here are a few example prompts, from simple to more advanced:

• Simple Prompt:
• Slightly More Complex Prompt:
• A specific prompt with sorting:

Step 3: Watch Looker Generate the Chart

Once you enter your prompt, Looker's AI gets to work. It does several things behind the scenes:

• Identifies the right data source to answer your question.
• Picks the correct dimension (e.g., 'Country', 'Traffic Source').
• Selects the appropriate measures (e.g., 'Total Sales', 'New Users').
• Automatically chooses the column chart type you requested.

In just a few seconds, an initial version of your chart will appear. You've just saved yourself all the time you'd normally spend locating fields and configuring settings.

Step 4: Refine and Customize with Follow-Up Questions

The AI-driven process isn't just a one-shot deal. You can continue the conversation to tweak the chart to your liking. Think of this as making edits without ever opening the settings panel.

You can ask for changes like:

• "Change it to a stacked column chart."
• "Sort this in descending order."
• "Add data labels to each column."
• "Change the color for the 'United Kingdom' to green."
• "What percent of traffic comes from the United States?"

This iterative process allows non-technical users to build reports that would have previously required deep knowledge of the tool, democratizing data access for the whole team.

Building a Column Chart The Manual Way

Even with powerful AI, it's still useful to know how to build a chart manually. You may need to fine-tune a detail the AI can't quite grasp or you might just prefer the hands-on control. Here's the traditional step-by-step process in Looker.

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

Step 1: Get Started with an Explore

An "Explore" is Looker's starting point for any data investigation. Select the Explore that contains the data you need. For example, if you want to analyze website data, you might start with a "Website Analytics" Explore.

Step 2: Select Your Dimensions and Measures

In the left-hand panel, you'll see a list of available fields, divided into Dimensions and Measures.

• Dimensions: These are the things you want to group your data by - the textual or categorical fields. For a column chart, this will be your X-axis. Common examples include Date, Country, Product Category, or Campaign Name.
• Measures: These are the numbers you want to analyze - the quantitative fields. This will be your Y-axis value. Common examples include Total Sales, Sessions, Cost, or Number of Users.

Click on the fields you want to use. For example, to see your website traffic by country, you would click on the "Country" dimension and the "Sessions" measure.

Step 3: Run Your Query

After selecting your fields, click the Run button. Looker will fetch the data and display it in a table by default. This is a good way to check that you've selected the right data before you visualize it.

Step 4: Choose the Column Chart Visualization

With your data table showing, navigate to the Visualization pane. Looker displays a series of chart icons. Click on the one that represents a column chart. The data table will immediately transform into a column chart.

Step 5: Customize Your Chart in the "Edit" Panel

Looker gives you extensive control over the look and feel of your chart. Click the Edit button in the visualization pane to open a deep menu of options. Here are some of the most common adjustments you might make:

• Plot: Choose between a standard column chart or a stacked one. You can also reverse the X and Y axes if needed.
• Values: Add value labels to show the exact number on top of each column, which can improve readability. You can also control the formatting of the numbers (e.g., show as currency, change decimal places).
• X and Y Axis: Change the axis labels, adjust the scale, add or remove gridlines, and format the tick marks to make your chart clear and professional.

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

Proven Tips for Better Column Charts

Building a chart is one thing, building a good chart is another. Here are a few best practices to ensure your column charts are effective and easy to understand.

Start the Y-Axis at Zero: Always start your value axis at zero. Starting it higher can exaggerate the differences between columns and mislead your audience. The power of a column chart comes from comparing the full height of each bar.

Keep it Clean: Don't try to cram too much information into one chart. If you have ten or more categories, the chart will become crowded and hard to read. In such cases, consider grouping smaller categories into an "Other" bucket or using a bar chart for better label visibility.

Order Your Data Logically: How you order your columns matters. You can sort them alphabetically if there's no inherent order. More often, it’s best to sort them in ascending or descending order. This immediately draws attention to the highest and lowest values.

Use Color with Purpose: Color shouldn't just be decorative. Use brand colors for consistency. Use a single, neutral color unless you want to highlight a specific data point, in which case a strong, contrasting color is very effective.

Final Thoughts

Whether you're using a simple spoken command or diving into the manual editor, Looker provides powerful and flexible ways to create insightful column charts. The new AI features dramatically slash the time it takes to get from a question to an answer, while the classic approach still offers granular control for perfecting your visualizations.

Building dashboards should be a quick, conversational process across all your data sources. At my company, we built Graphed to do exactly that for busy marketing and sales teams. Instead of waiting on an analyst or struggling with different reporting a dozen platforms, you can connect your Shopify, Google Analytics, Salesforce, and ad accounts in seconds. Then, you can simply ask for what you need - "Show me my ad spend versus revenue for all Facebook campaigns this month" - and get a live, interactive dashboard built for you instantly that updates itself automatically.