Google Sheets Chart Themes: How to Set and Customize

In Google Sheets, a chart’s appearance can come from the spreadsheet’s overall theme or from settings on the chart itself. To apply a spreadsheet theme, open Format > Theme and choose one; to adjust a particular chart, select it, open its three-dot menu, choose Edit chart, and use the Chart editor’s Customize tab.

What chart themes mean in Google Sheets

The phrase chart theme can refer to two related things: the theme applied to the whole spreadsheet, and the visual settings chosen for an individual chart. Google Sheets does not present a separate, standalone chart-theme gallery inside the Chart editor. Instead, a spreadsheet theme sets shared visual defaults, while chart controls let you refine a chart’s colors, typography, background, labels, and other elements.

This distinction matters when a chart looks different from what you expect. Applying a new spreadsheet theme may change the document’s overall visual treatment, but it is not the same as manually assigning a color to every series or changing a chart title. Chart-specific formatting can take precedence over a general default, so a custom-colored series may not change just because you selected another theme.

Themes are useful when you want several charts and other spreadsheet elements to feel consistent. Individual chart settings are useful when a chart has a special purpose, such as highlighting one product category or making a small chart legible on a dashboard.

Apply or customize a spreadsheet theme

In Google Sheets in a web browser, choose Format > Theme. The Themes panel displays available designs. Select one to apply it to the spreadsheet. To adjust the selected theme, use the panel’s customization controls, which let you change options such as the theme’s font and colors. Available choices can vary as Google updates the interface.

A practical way to work is to choose a theme before spending time formatting every chart. Then review the charts and apply chart-level changes where the theme’s defaults do not suit your data. If you later switch themes, check important charts again rather than assuming every detail will be preserved or automatically improved.

Choose a theme that gives the sheet a coherent starting point, rather than a theme based only on one attractive color.
Check text and chart backgrounds for enough contrast, especially if the sheet will be projected or printed.
Use a small set of distinct series colors so readers can identify categories consistently across charts.
After changing a theme, inspect titles, legends, data labels, and chart backgrounds as well as the plotted colors.

Applying a theme changes the spreadsheet’s presentation, not its underlying cell values or chart data range. It is a formatting choice; it does not recalculate figures or change what the data means.

Customize a chart independently

To change one chart, click it and open Edit chart. The Chart editor opens with a Setup tab and a Customize tab. Setup controls the chart type and data arrangement. Customize controls appearance and chart elements. The exact sections shown depend on the chart type, so a pie chart and a line chart do not offer identical controls.

In Customize > Chart style, you can adjust options such as the chart background, border, and font, and, where offered, settings such as 3D presentation. Other sections may include chart and axis titles, series, legend, horizontal axis, vertical axis, and gridlines and ticks. Expand a section to see its available settings. Changes appear on the chart as you make them.

To format a data series, open Customize > Series and select the series you want to edit. You can change its color and, depending on the chart type, other properties such as line or point appearance. For example, in a monthly sales chart, you might keep the same blue for the North region across related charts and use orange for the South region. Consistent mapping helps readers compare charts without relearning the legend each time.

For titles, use Customize > Chart & axis titles, choose which title to edit, then enter the title text and adjust its formatting. A useful title states the measure and context, such as Monthly revenue by region, rather than a vague label like Results. The chart’s source data and its visible title are separate: editing the title does not change the data selection.

Create a chart, then style it

If you are starting from a table, select the data range, including useful column headings, and choose Insert > Chart. Sheets creates a chart and opens the Chart editor. Review Setup first: confirm that the selected data range is correct, the chart type fits the question, and the headers are being used as labels or series names as intended. Then use Customize to apply a theme-compatible look.

Arrange the data in a clear table, with one row or column for labels and adjacent values for the series.
Select the relevant range and choose Insert > Chart.
In Setup, choose an appropriate chart type and correct any range or label problems.
In Customize, set the chart style, title, series colors, legend, and axes as needed.
Resize the chart and review it at the size readers will actually see.

For example, a table with months in the first column and sales for three regions in the next columns can support a line chart for comparing trends. A theme can provide a coordinated starting palette, but you should still check that all three lines are distinguishable. If the chart is too crowded, removing decorative effects or reducing the number of series may help more than adding further styling.

Choose colors and styles for the data

A good theme is not simply a set of attractive colors. It should make the data easy to interpret. Use color to communicate a stable distinction, such as product or region, and avoid changing that mapping without a reason. If red means losses in one chart and a particular department in another, readers may have to stop and decode the graphics.

Consider these choices when selecting a theme or adjusting chart colors:

Contrast: Make labels and plotted marks visible against the chart background. Pale lines on white can disappear, particularly when projected.
Color accessibility: Do not rely on color alone to distinguish categories. Labels, line patterns where available, or direct annotations can provide another cue. Check that important distinctions remain understandable to readers with color-vision differences.
Series count: A palette that works for two series may become confusing with ten. Consider whether the chart type or data grouping should change.
Purpose: A presentation chart may need larger text and fewer gridlines than a chart intended for close analysis in a spreadsheet.
Consistency: Reuse colors for the same categories across a dashboard, while keeping enough contrast between categories that appear together.

Use decorative options sparingly. A three-dimensional effect can make a chart look more prominent, but it can also make values harder to compare because perspective changes the apparent size of marks. For precise comparisons, a simple two-dimensional chart is often easier to read. Styling should clarify the evidence, not compete with it.

Theme versus chart style: what changes?

A spreadsheet theme provides shared formatting defaults across the file. Chart style settings act on the selected chart or chart element. Think of the theme as a coordinated starting point and chart customization as the set of local adjustments. If a series has been given a specific color, for example, that explicit choice may remain even when you change the overall theme. If a chart does not respond as expected, inspect its individual settings rather than repeatedly switching themes.

Google Sheets is also different from Microsoft Excel in how users encounter these controls. Excel for Microsoft 365 on Windows has workbook themes and chart formatting controls on its ribbon, including chart-specific design options. Google Sheets uses the browser-based menus and Chart editor described here. The general idea of a document-wide theme plus chart-level formatting is familiar in both programs, but menu names and the available controls are not identical. Instructions for Excel should not be assumed to match Sheets click for click.

A theme is not a chart template that stores every detail of a finished graphic. If a particular chart design needs to be reproduced, it is sensible to keep a reference chart or document the choices used, such as series colors, title wording, and axis treatment. That makes later maintenance easier than relying on memory or expecting a theme to capture every local choice.

Common chart theme problems

The chart colors did not change: The colors may have been set directly on a chart’s series, or the selected theme may not alter the particular element you are checking. Open Edit chart > Customize > Series, select each relevant series, and review its color. Also check the chart background and text separately.

The chart is hard to read after a theme change: A theme can create a combination that looks coordinated but has weak contrast at the chart’s actual size. Increase text size where appropriate, choose stronger series colors, and check the legend and axis labels. Do not assume that a dark background automatically means every label will be easy to see.

A chart has the wrong categories or labels: This is usually a setup issue, not a theme issue. Open the Setup tab and review the data range, category axis, series, and header options. Correcting the source table’s structure can also prevent Sheets from interpreting labels as values or values as labels.

The chart looks different to a collaborator: Confirm that the collaborator is viewing the same spreadsheet and that edits have been saved and synced. If the chart is embedded or copied into another document, its appearance may depend on how it was inserted and whether it remains linked. Ask the recipient to open the source spreadsheet when you need them to see the current chart and its surrounding data.

The chart is attractive on screen but poor on paper: Print preview can reveal small type, weak lines, or a background that uses too much ink. Review the chart at its final size and consider a simpler background and stronger contrast. A theme that works on a monitor is not automatically optimized for a monochrome printout.

Sharing, printing, and accessibility

Charts often travel beyond the spreadsheet, so check the context in which people will read them. A dashboard viewed on a laptop can accommodate more detail than a slide or printed report. Keep titles specific, avoid unnecessarily small labels, and make the chart large enough to read. If a chart is copied into another file or exported, verify the resulting version rather than assuming its formatting will look identical everywhere.

Accessibility is also a design concern, not merely a palette choice. Use meaningful chart titles, clear category labels, and a legend that can be matched to the plotted data. Where color is the main distinction, add another visual cue when possible and avoid combinations that are difficult to tell apart. Keep the source table available so readers can inspect exact values; a chart is a visual summary, not always a substitute for the underlying data.

For collaborative sheets, agree on a small set of styles for recurring categories and chart types. This can make a multi-chart report easier to scan. Before sharing, verify that the chart uses the intended data range and that changes to the source table have not added blank categories or omitted recent rows. Theme consistency cannot compensate for an incorrect chart range.

Frequently Asked Questions

Can I apply a theme to only one chart in Google Sheets?
Spreadsheet themes apply to the spreadsheet rather than serving as a one-chart theme selector. To change just one chart, select it, choose Edit chart, and make local adjustments in the Chart editor’s Customize tab.

Where do I find chart colors in Google Sheets?
Select the chart, open Edit chart > Customize > Series, and choose the series to format. The available controls depend on the chart type. Chart background and text options are in other Customize sections, including Chart style and Chart & axis titles.

Will changing the spreadsheet theme change existing charts?
It can affect the spreadsheet’s shared visual defaults, but do not assume every manually formatted chart element will be replaced. Review the chart after changing themes and adjust its own settings if a color, font, or background does not match your intention.

Can I save a custom chart theme for every chart?
Sheets offers spreadsheet themes and chart-level controls, but the Chart editor is not a separate gallery for saving a complete reusable chart theme. For repeatable charts, keep the same spreadsheet theme, reuse consistent formatting choices, and document or retain an example chart for reference.

Why are some chart formatting options missing?
Options vary by chart type and the element selected. A pie chart, for example, does not use the same axes as a line chart. Check that you are editing the intended chart and series, and remember that controls in the browser interface can change as Google updates Sheets.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.