How to Edit Chart in Google Sheets

Creating a chart in Google Sheets is often the easy part, the real challenge is transforming that default chart into a clear, professional, and persuasive visual. A well-edited chart can make the difference between a confusing data dump and a compelling story that drives decisions. This guide will walk you through every option in the Google Sheets chart editor, showing you how to customize everything from titles and colors to axes and data labels.

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

Getting to Know the Chart Editor

The Chart editor is your command center for all things visual. Once you have a chart, you can open the editor in one of two ways:

• Double-click anywhere on your chart.
• Single-click on the chart to select it, then click the three vertical dots in the upper-right corner and choose “Edit chart.”

This will open a panel on the right side of your screen with two main tabs: Setup and Customize. Think of them this way:

• Setup: This tab focuses on the data and structure of your chart. Here you’ll change the chart type, adjust your data range, and define what goes on your X and Y axes.
• Customize: This is where you control the chart's appearance and aesthetics. You’ll spend most of your time here, tweaking colors, fonts, titles, gridlines, and legends to make your chart look exactly right.

Mastering the 'Setup' Tab

Before you make your chart pretty, you need to make sure its foundation is correct. The Setup tab helps you build that solid foundation by defining what data is shown and how it's structured.

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

Changing Your Chart Type

Sometimes the chart Google Sheets suggests isn't the best fit for your data. You can easily switch it.

1. In the Setup tab, the first option is “Chart type.”
2. Click the dropdown menu to see dozens of options, from basics like line and bar charts to more advanced types like waterfall and candlestick charts.

Practical Tip: When should you switch chart types? If you want to show a trend over time (e.g., website traffic per month), a line chart is ideal. If you're comparing distinct categories (e.g., sales per product), a column or bar chart is clearer. If you need to show parts of a whole (e.g., budget allocation by department), a pie chart works best.

Adjusting Your Data Range

Your data range specifies which cells in your sheet are being used to create the chart. You might need to edit this if you add new data or want to exclude certain rows or columns.

To change it, click the grid icon next to the "Data range" field. You can then either type in the new range (e.g., A1:C25) or click and drag over the cells you want to include in your sheet.

Example: Let’s say your chart shows sales from January to June (A1:B7). If you add July's data in row 8, you'll need to update your data range to A1:B8 to include it in the chart.

Working with the X-Axis and Series

Below the data range, you’ll define what data goes where.

• X-axis: This represents the labels for your data points - typically time periods (months, years) or categories (product names, countries).
• Series: These are the numerical values being measured and plotted on the chart (sales, costs, user counts). You can plot multiple series on the same chart to compare them, like showing "Revenue" and "Profit" on the same line graph.

To add a new series, simply click "Add series" and select the data range containing the values you want to plot. This is perfect for comparing two related metrics side-by-side.

Diving into the 'Customize' Tab

This is where you bring your chart to life. The Customize tab is organized into collapsible sections, each controlling a different aspect of your chart's appearance. Let's go through the most important ones.

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

Chart style

This section controls the overall appearance of your chart.

• Background color: Change the background of the chart area. A subtle off-white or light gray can look more professional than the stark default white.
• Font: Set a global font for all text on your chart for a consistent look.
• Border color: Add a border around your chart to help it stand out, especially when placed on a dashboard with other elements.
• Maximize: This is a useful feature. Ticking this box reduces the empty white space around the plotting area, making your data the center of attention.

Chart & axis titles

A chart without a clear title is just a picture. Make yours informative.

1. In the “Chart & axis titles” section, you can select which title you want to edit from the dropdown (Chart title, Horizontal axis title, Vertical axis title).
2. Type your descriptive text in the "Title text" box. Instead of "Sales," try something more specific like "Quarterly Product Sales (Q3 2023)."
3. Below, you can adjust the font, size, color, and format (bold/italic) of your titles. Bold titles typically stand out better.

Series

This is arguably the most powerful section for customization, as it allows you to format each individual data series differently.

First, use the dropdown at the top to select the series you want to edit (e.g., "Sales" or "Expenses"). Then, you'll see a range of options:

• Color: Change the color of the bars, lines, or pie slices. Use your brand colors for a consistent feel or contrast to make different series easy to distinguish.
• Axis (Left/Right): This is an essential feature for combo charts. If you're plotting two series with vastly different scales (like Revenue in millions of dollars and Click-Through Rate as a small percentage), you can assign one to the left axis and the other to the right. This prevents one series from looking like a flat line at the bottom of the chart.
• Line thickness / Point size: For line charts, you can make important lines thicker or add circular or triangular markers to distinguish multiple lines.
• Data labels: Check this box to display the exact numerical value on each bar, point, or slice. This helps readers easily see specific values without guessing based on axes. You can customize the position, font, and format of these labels.
• Trendline: With one click, you can add a trendline to scatter plots and bar/line charts to visualize the general direction of your data over time—up, down, or flat.

Effectively using the Series editor is what elevates a basic chart to a professional-grade visualization.

Legend

The legend explains what the different colors or symbols in your chart represent. You can control its position (Top, Bottom, Left, Right, or Inside), font, and color to best fit your chart's layout.

Tip: If your chart only has one data series, the legend is redundant. You can set the Position to "None" to remove it and give your data more space.

Horizontal/Vertical Axis

These sections give you precise control over your axes.

• Label font/size/color: Adjust the text on the axes for readability.
• Min and Max: This is a critical but often overlooked feature. Google Sheets automatically sets the minimum and maximum values for your vertical axis, but you can override this. For example, if your sales data ranges from $50,000 to $55,000, setting a Min of 0 will make the variations look small. Setting a Min of $48,000 will zoom in on the data and make the fluctuations more obvious. Just be careful not to mislead your audience! Always starting your axis at zero is the most honest way to represent data.
• Number format: You can quickly format your axis labels here. If you're showing money, change the format to Currency. If you're showing percentages, choose Percent. You can also specify the number of decimal places.

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

Gridlines and Ticks

Gridlines help guide the reader's eye from the axis to the data points. Here, you can change their color, thickness, and frequency (Major gridlines vs. Minor gridlines).

Design Tip: Heavy, dark gridlines can make a chart look cluttered. For a cleaner, more modern look, set your gridline color to a light gray. If you're using data labels, you might not even need gridlines at all—you can uncheck the box to remove them completely.

Pro-Tips for Faster Editing

• Edit Elements Directly: You don't always have to navigate through the Customize panel. You can double-click directly on most chart elements—the title, an axis, a data series, or the legend—and Google Sheets will automatically open the Chart editor panel to the correct section for that element.
• Copy Chart Formatting: Once you have a chart styled perfectly, you don't have to repeat the process. Click on your styled chart, press Ctrl+C (or Cmd+C), then click on a new, unformatted chart, and use the "Paste special" command (Ctrl+Alt+V or Cmd+Option+V) to paste only the chart format. This ensures consistency across all your reports.

Final Thoughts

By learning to navigate the Setup and Customize tabs, you unlock the ability to turn default Google Sheets outputs into clear, professional, and insightful visuals. Taking the time to adjust titles, colors, axes, and labels transforms your chart from a simple output into a powerful communication tool.

Manually fine-tuning every chart can be time-consuming, especially when you manage multiple reports across different marketing and sales platforms. We built Graphed to automate this heavy lifting. By connecting data sources like Google Analytics, Facebook Ads, and Shopify, you can simply ask for the visuals you need in plain English. Graphed instantly builds live, interactive dashboards so you can skip the manual setup and styling and get straight to the insights that grow your business.