How to Change Name of Pie Chart in Google Sheets

Your pie chart looks great, but its default title - probably just your column header - isn’t telling the full story. A well-named chart can be the difference between a dashboard that’s glanced at and one that’s truly understood. This guide will walk you through the simple steps to rename your pie chart in Google Sheets, customize its appearance, and even share some best practices for crafting titles that make your data clear and impactful.

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

Before You Begin: Creating a Pie Chart in Google Sheets

If you already have your chart ready, you can skip ahead. But for those just starting, let's create a quick pie chart as our working example. It only takes a minute.

Imagine you have data showing where your website traffic comes from. Your sheet might look something like this:

Example Data:

• Column A: Source (e.g., Organic Search, Direct, Social Media, Referral)
• Column B: Sessions (e.g., 5,430, 2,110, 1,580, 890)

Here’s how to turn that data into a pie chart:

1. Select your data: Click and drag to highlight the cells containing your sources and their corresponding session numbers. Be sure to include the headers ("Source" and "Sessions").
2. Insert the chart: Go to the main menu and click Insert > Chart.
3. Choose the chart type: Google Sheets is pretty smart and will often default to a pie chart for this kind of data. If it doesn't, navigate to the "Chart type" dropdown in the Chart editor on the right side of your screen and select "Pie chart."

You now have a pie chart on your sheet, but its title likely just says "Sessions." That's not very descriptive. Let's fix it.

Method 1: The Quickest Way to Change the Name (Double-Clicking)

The most straightforward method for renaming your chart is to edit the title directly on the chart itself. It’s intuitive and fast for simple changes.

Step-by-Step Instructions:

1. Select the chart title: Simply double-click on the existing title of your pie chart.
2. Start typing: A text box will appear, and you can immediately start typing to change the name. You can delete the old text and write your new title.
3. Confirm the change: Once you've entered your new title, just click anywhere outside of the text box to save the change.

For our example, you could change "Sessions" to something much better, like "Website Traffic by Source - Q3 2024." This is perfect for a quick, one-off edit.

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

Method 2: Using the Chart Editor for More Customization

For more control over your chart's title and overall appearance, the Chart Editor is your best friend. This is where you can not only change the text but also adjust fonts, colors, and add subtitles for additional context.

How to Access and Use the Chart Editor:

1. Open the editor: First, click once on your pie chart to select it. Then, click the three vertical dots (the "kebab menu") in the top-right corner of the chart and select "Edit chart." The Chart editor will open as a sidebar on the right.
2. Navigate to the Customize Tab: At the top of the Chart editor sidebar, you’ll see two tabs: "Setup" and "Customize." Click on the "Customize" tab.
3. Find the Title Options: Click on the accordion menu item labeled "Chart & axis titles." This section contains all the settings related to your chart’s titles.
4. Change the Title Text: In the text box labeled "Title text," you can type in your new chart name. As you type, you'll see the title on your chart update in real-time. This is great for an instant preview of how it looks.
5. Add a Subtitle (Optional but Recommended): Below the main title text box, you'll find an option to add a "Chart subtitle." Subtitles are incredibly useful for adding context without cluttering the main title. For example, your main title could be "Website Traffic by Source," and your subtitle could be "Jul 1 - Sep 30, 2024." This keeps your presentation clean and organized.
6. Format Your Title: This is where the Chart Editor really shines. You can make your title stand out by formatting it to match your brand or report style. Options include:

Using the Chart Editor is the most reliable way to make changes stick and gives you the professional finish that helps your data get noticed.

Troubleshooting: Why Does My Chart Title Keep Resetting?

Have you ever painstakingly renamed your chart only to have it change back to the original text a day later? This is a common and frustrating issue in Google Sheets. It usually happens because your chart title is still dynamically linked to your data's column headers.

Google Sheets tries to be helpful by automatically titling your chart based on the headers of the data you selected. For example, if you titled your data column "Sessions," the chart takes that as its name. If you or a collaborator later changes that column header (e.g., to "Visits"), the chart title often "helpfully" updates itself, wiping out your manual change.

How to Fix It and Make Your Title Permanent:

The solution is to manually set the title using the Chart Editor as described in Method 2 above. When you enter a new title in the "Title text" box under Customize > Chart & axis titles, you are overriding the default link to the column header. This essentially tells Google Sheets, "Stop trying to be smart, use this title from now on."

Once you set a custom title in the editor, it will no longer change automatically when you edit your source data headers.

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

Best Practices for Naming Your Charts

Knowing how to change a title is one thing, but knowing what to change it to makes all the difference. A great title provides context and clarifies the data without the viewer having to work for it. Here are a few tips:

1. Be Descriptive but Concise

Your title should answer the question, "What am I looking at?" as clearly as possible. It should convey the main takeaway of the chart.

• Bad Title: Pie Chart
• Okay Title: Sales
• Good Title: Q3 New Sales by Product Category

2. Include the Time Period

Data without a time frame is often meaningless. If your chart represents data from a specific month, quarter, or year, make sure to include it in the title or subtitle.

• Example: "Social Media Referrals - May 2024" or use a subtitle for the date range.

3. Avoid Redundant Phrasing

Steer clear of phrases like "Chart of..." or "A Pie Chart Showing..." Viewers can already see it's a pie chart. The title is for interpreting the data, not describing the chart type.

• Instead of: "A Pie Chart of Ad Spend by Channel"
• Use: "Ad Spend Breakdown by Channel"

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

4. Consider Your Audience

Who will be reading this chart? If it's for an executive team, focus on the high-level insight (e.g., "Market Share by Competitor"). If it's for a marketing team deep dive, you can get more specific (e.g., "Conversion Rate per MQL from Paid Campaigns").

Final Thoughts

Renaming a pie chart in Google Sheets is a simple task that has a big impact on the clarity and professionalism of your reports. Whether you prefer the quick double-click method or the deeper customization available in the Chart Editor, taking a moment to write a clear, descriptive title will ensure your audience immediately gets the point of your data.

Building charts manually, formatting titles, and refreshing data week after week is a time-consuming part of marketing and sales reporting. Here at Graphed, we automate that entire frustrating process. Instead of downloading CSVs and wrestling with chart editors, you can connect your data sources (like Google Analytics, Shopify, or ads platforms) and just ask for the report you need in plain English: "Show me a pie chart of my website traffic by source for last quarter." We instantly build a live, interactive dashboard for you, so you can spend less time editing reports and more time acting on the insights they provide.