How to Edit a Graph in Google Sheets

You've already created a basic chart in Google Sheets, but it doesn't look quite right. Maybe the colors are off, the title is missing, or it’s not showing the right data. This guide will walk you through exactly how to edit your graph to make it clear, professional, and tell the right story. We’ll cover everything from changing a chart type and adjusting colors to modifying specific data points and adding trendlines.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Getting Started: Your Command Center for Chart Editing

Google Sheets centralizes all its chart editing tools in a single sidebar menu called the Chart editor. To get started, simply double-click anywhere on your chart. This action will open the editor on the right side of your screen.

If you accidentally close it, don't worry. Just click on the chart once to select it, then click the three vertical dots (kebab menu) in the top-right corner of the chart and choose "Edit chart."

The Chart editor has two main tabs that you'll use for all your edits:

• Setup: This is where you control the chart's foundation - what type of chart it is (bar, line, pie), what data it displays, and how that data is structured.
• Customize: This is your creative canvas. Here you’ll change the visual elements, such as colors, fonts, titles, labels, and gridlines to improve the look and feel of your chart.

Let's go through the most common edits you'll want to make, starting with the Setup tab.

Changing Your Chart’s DNA: The 'Setup' Tab

The Setup tab lets you amend the core structure of your graph. It is important to perfect your setup tab before spending hours perfectly customizing it, because a change of chart types might completely remove the customizations you have done.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Changing the Chart Type

Sometimes you realize that a bar chart would be more effective than a line chart or that a pie chart is the best way to show parts of a whole. Changing this is easy.

1. With the Chart editor open, stay on the Setup tab.
2. Click the dropdown menu under "Chart type."
3. Select the new chart type from the list. Google Sheets will instantly transform your chart.

Pro Tip: Google Sheets will also suggest different chart types based on the structure of your data. The suggestions near the top of the list often offer the most effective way to visualize your selected range.

Adjusting the Data Range

What happens if you want to add more data to your chart, like a new month's sales figures, or remove a category you no longer need? You can easily adjust the data range your chart is pulling from.

1. In the Setup tab, look for the "Data range" field.
2. Click the grid icon on the right side of this field.
3. A dialog box will pop up, and you can either type in a new range (e.g., A1:C13) or click and drag over the cells you wish to include in your sheet.
4. Click "OK." Your chart will update immediately to reflect the new data range.

Grouping and Stacking Data

Another powerful feature in the 'Setup' tab is Stacking. You’re likely used to the normal column bars that represent a certain amount. For example, you might track the amount of fruits you are selling in different states and use a normal chart column. With stacking, we can visualize your total fruits sold with one bigger stack chart which is divided by colors according to the states that sold them.

1. In the Setup tab go to the Stacking dropdown menu.
2. Choose between the three different stacking options: None, Stacking, or Percent.
3. Visualize how these different options can showcase different conclusions from the data.

Fine-Tuning Columns and Rows

Google Sheets does a great job picking how your data should be displayed, but from time to time it might not represent the data you want correctly. Your ‘x-axis’ might not be your desired labels, or you might want them as chart ‘series’.

Key Setup Actions:

• X-Axis: Select what range will act as your labels for your graph. In sales, the X-axis is often your time period (e.g., months).
• Series: These are the data sets being plotted. For example, if your X-axis is "Month," your Series might be "Product A Sales," "Product B Sales," and "Product C Sales." Each one becomes a different colored bar or line.
• Switch rows/columns: A one-click fix that transposes your data. This often immediately resolves issues where your axes are flipped from what you intended.
• Use row 1 as headers: Ensures Google Sheets correctly interprets the first row as series names rather than data points.
• Use column A as labels: Sets the first column as labels on your horizontal axis.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Bringing Your Chart to Life: The 'Customize' Tab

Once your data is structured correctly on the Setup tab, it's time to make your chart look great. The Customize tab offers a deep well of options to change nearly every aesthetic aspect of your graph.

Chart Style

This section controls the overall appearance of your chart in the most macro ways:

• Background color: Change the color behind the entire chart container.
• Font: Set a universal font for all text on the chart.
• Chart border color: Add a border and select the color this will have. Consider theming your chart to always represent your company’s values and themes.
• Maximize: This option tries to give more room for the data chart, sacrificing room for other elements like legend or axis labels. This feature can be helpful when making bigger complex charts, but if your intention is to showcase this result in an important context, it shouldn't be your go-to option.

Chart & Axis Titles

A good chart needs a self-explanatory title and clearly labeled axes. That’s done in this section:

1. Click the Chart & axis titles dropdown in the Customize menu.
2. Select the title you want to edit (Chart title, Chart subtitle, Horizontal axis title, or Vertical axis title).
3. In the "Title text" box, type in your desired text.
4. Below, you'll find a wide selection of further edits: Change the font, size, bold, italic, or even change its color. Take advantage of it to make your graph more memorable!

Series

In this section you will manage how the actual representation of the data is displayed on your screen. These features are completely dependent on your chart, meaning not all of them might appear in all charts.

Customizing an Individual Series:

1. Under the Series menu, use the selector to switch between the set of features that affect the series on all of our graph by using the ‘apply to all series’ option, or choose one or more specific series. This will only affect a single dataset at a time.
2. Once your preferred series is selected, change its Color and Line thickness.
3. For example, with the column bar, you can also change its fill or line color among other aesthetic features.

Key Series Options:

• Data labels: Adding these labels is one of the most useful changes in your graph data. In this section, we can also choose their type, position, or even font, size, and color to allow easier visualization. It will make your charts go from normal to professional.
• Trendline: For line charts, scatter plots, and some bar charts, you can add a trendline to help visualize the overall pattern. You will be able to also customize the type among them (linear, exponential, etc.), and its color or line width.
• Error bars: Useful for statistical data, they show potential variability or error in your measurements.

Legend

In the Legend section, we can define where this crucial piece of information might be positioned. Do you visualize better with the labels next to the graph? On the side? Or below? With the legend position, we have vast and precise power to place it. We can change the default settings on how they are displayed or adjust its font and color.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Gridlines and Ticks

Having your chart's background empty is always an option, but with this set of features, you can fully control the background grid or ticks to always have a reference about values on your chart.

1. Click into the section and start adding ‘Major gridlines.’
2. Once active, you also have the option of adding minor ones or controlling their ‘Count intervals.’
3. Take advantage of colors to highlight major gridlines to show more data in the graph without overloading the viewer's eye.
4. The same can be applied to Major ticks or Minor ticks. These, on the other hand, don’t extend across the graph but stay on the axis.

Other Time-Saving Tricks & Tips

Edit Individual Data Points for Emphasis

What if you want to highlight a certain achievement like a single month with exceptionally high sales or a single blog post showing great performance? Instead of changing the color of the entire series, you can edit and customize a single data column too.

1. Click once on the chart series (e.g., the set of blue bars) to select all bars in that series.
2. Click a second time, directly on the specific bar or data point you want to isolate.
3. Now, the formatting options in the Chart editor will only apply to that single point. This allows us to make that singular item stand out, making it even easier for viewers to notice what you want to highlight.

Move, Resize, Copy, and Publish

Other Important Actions You Will be Doing to your graph

• Move & Resize: Click and drag your chart to position it anywhere on your sheet. Pull the small blue squares on the corners and sides to resize it while keeping an accurate perspective between all assets and elements.
• Download your chart: Want to use it in other documents like presentations or emails? You may use the three dots at the top right corner. Once you do, a menu will open where you can select your downloadable choice from png, jpeg, or if you feel more adventurous, pdf, or svg too.
• Publish Your Chart: If you want your chart to be live on a website, you can publish it using the File menu or the '...' menu. This key feature ensures that an embedded version of the chart remains up-to-date with style changes automatically updating.

Final Thoughts

Mastering chart editing in Google Sheets allows you to turn a simple dataset into a powerful, professional visual story. Following these instructions, you should now feel confident in your Google Sheets editing journey since we covered the fundamentals to even advanced unique customizations.

When managing marketing or sales data, you often find that the hardest part isn't drawing the actual charts you'll use daily, but rather the tedious task of collecting data and bringing it into one spreadsheet. This frustrating cycle is exactly why we created Graphed. We help connect data resources from platforms like Google Analytics, Shopify, or Facebook Ads, and with our advanced AI, we create live dashboards efficiently.