How to Make a T Chart on Google Sheets

A T-chart is one of the simplest and most effective ways to brainstorm, compare ideas, or organize information. While a pen and paper work just fine, building your T-chart in Google Sheets makes it dynamic, shareable, and easy to edit. This article will walk you through exactly how to create a clean, functional T-chart in Google Sheets step-by-step.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

What is a T-Chart Anyway?

A T-chart is a type of graphic organizer used to compare two things side-by-side. It gets its name from its simple structure: a large letter "T" drawn on a page, creating two columns. A title goes above the "T," and each column gets a heading that describes the information listed below it.

Its power lies in its simplicity. This two-column format is incredibly versatile and can be used for things like:

• Pros and Cons: The most classic use case, perfect for making decisions.
• Cause and Effect: Listing the actions or events in one column and their outcomes in another.
• Fact vs. Opinion: Separating objective statements from subjective ones.
• Strengths and Weaknesses: A foundational part of any SWOT analysis.
• "Before" and "After": Showing change or progress over time.
• Accounting Ledgers: In its most technical form, a T-account uses this structure to track debits and credits for a specific account.

In short, if you need to quickly organize and visually separate two related sets of information, a T-chart is the perfect tool for the job.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Why Use Google Sheets for a T-Chart?

You can certainly draw a T-chart on a whiteboard or a piece of paper, but using a spreadsheet like Google Sheets gives you a few key advantages:

• Easy to Edit: Did you think of another "pro" for your list? Just add a new row. There's no need for erasing or trying to squeeze text into a small space. You can easily add, delete, and reorder items.
• Collaboration in Real-Time: Need to brainstorm with your team? Share the Google Sheet and everyone can add their ideas simultaneously. You can see their changes as they happen, making group sessions more efficient.
• Clean Formatting: With just a few clicks, you can add colors, bold text, resize columns, and create clean borders to make your T-chart professional and easy to read.
• Reusable Templates: Once you create one T-chart, you've essentially created a template. Just duplicate the sheet, clear the contents, and you're ready for your next comparison.
• Cloud-Based Accessibility: Your charts are saved automatically and can be accessed from any computer or mobile device. No more losing that important piece of paper.

How to Make a T-Chart in Google Sheets: Step-by-Step Guide

Creating the T-chart look in Google Sheets doesn't involve selecting from a chart menu. Instead, you'll use basic formatting tools - specifically the Borders tool - to draw the "T" shape yourself. It's easier than it sounds. Let's get started.

Step 1: Set Up the Title

First, open a new Google Sheet. You don’t need much space, so two columns will be enough for the chart itself. We'll start with the title.

1. Click into cell A1 and type the title of your T-chart. For this example, let's use "Choosing a New Project Management Software."
2. Since the chart will span two columns (A and B), you'll want to center the title over them. To do this, click and drag to select both cell A1 and B1.
3. With both cells selected, navigate to the toolbar and click Format > Merge cells > Merge horizontally. This combines the two cells into one, and your title should now be centered over the first two columns.
4. Make the title stand out by formatting it. Select the merged cell, make the text bold, and increase the font size.

Step 2: Add Your Column Headers

Now, let's define what each side of our chart represents. We'll create headers directly below the title.

1. In cell A2, type the header for the left column. Let's go with "Pros."
2. In cell B2, type the header for the right column. We'll use "Cons."
3. Just like the title, format these headers to make them clear. Select both A2 and B2, and make the text bold. You might also want to add a light background color to the header row using the Fill color tool (it looks like a paint bucket) to help it stand out.

At this point, you have the text foundation for your chart, but it doesn't visually look like a "T" yet. That's our next step.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step 3: Draw the "T" Shape with Borders

This is where the magic happens. We will use the Borders tool in the toolbar to create the lines of our T-chart.

Create the Horizontal Line:

1. Select your header cells, A2 and B2.
2. In the toolbar, find the Borders icon (it looks like a square with four smaller squares inside, or a window pane).
3. From the pop-up menu, select the Bottom border option. A line will appear under "Pros" and "Cons," forming the top bar of your "T."
4. Optional Tip: You can make this line thicker to give it more definition. After applying the border, click the Borders icon again, and find the Border style option in the bottom right of the pop-up. You can select a thicker line weight.

Create the Vertical Line:

1. Now, we need the long vertical line that separates the two columns. Click and drag to select all the cells where your data will go, starting from the header. For now, let’s select from A2 down to B20 (A2:B20).
2. Click the Borders icon again.
3. This time, select the Vertical border (or Inner borders) option. This will draw a line down the middle, perfectly separating Column A from Column B and finishing your "T" shape.

You now have a visually distinct T-chart, primed and ready for your data!

Step 4: Fill in Your Information

This is the easy part. Click into cell A3 to start listing your "Pros" and cell B3 to start listing your "Cons." Press Enter to move down to the next row as you add more points to each list.

Step 5: Polish Your Chart with Extra Formatting

Your chart is functional now, but a few small tweaks can make it much more readable and professional.

• Adjust Column Widths: If your text is spilling over, you can widen the columns. Hover your mouse over the line between the column headers (between A and B) until your cursor turns into a double-sided arrow. Double-click to automatically resize the column to fit the content, or click and drag to resize it manually.
• Use Text Wrapping: For longer points, you can make the text wrap within the cell instead of flowing into the next one. Select the cells with long text, then go to Format > Wrapping > Wrap.
• Add an Outer Border: Want to visually contain your chart? Select your entire T-chart area (e.g., A1:B20), click the Borders icon, and select Outer borders. This puts a nice frame around the whole thing.

Practical Example: A "YouTube Video Ideas" T-Chart

Let's use the steps above to create a T-chart for a content creator brainstorming YouTube video ideas. This example shows how you can adapt the chart for different kinds of comparisons.

1. Title: In A1 (merged with B1), we type "Brainstorming Future Video Topics."
2. Column Headers: In A2, we put "High Effort, High Reward" and in B2, we put "Low Effort, Quick Wins."
3. Borders:
4. Data Entry:

Instantly, the content creator has a clear, organized view of their ideas, categorized by the effort required. This simple but structured format helps prioritize what to work on next.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Final Thoughts

Creating a T-chart in Google Sheets is a fantastic way to bring clarity to your decision-making and brainstorming sessions. By using the merge and border tools, you can quickly build a simple, effective organizer that's easy to edit, share, and reuse for any comparison you need to make.

While tools like T-charts are great for manually comparing ideas, reporting gets more complex when you're trying to analyze performance data from platforms like Google Analytics, Shopify, or your CRM. At some point, manually exporting data or building reports in spreadsheets gets too slow. We built Graphed for that exact reason. Instead of wrangling data yourself, you just ask for the report you want in plain English - for example, "Create a dashboard showing my sales pipeline from HubSpot this quarter" - and get a live, interactive dashboard instantly. It's the easiest way to connect all your data and get answers in seconds, not hours.