THE EXCEL GUIDE Mastering Data & Spreadsheets

Home
Charts and Visualization

Chart Colors Excel: Customize Like a Pro

Learn how to apply themes and color schemes.
By:

Is your chart data correct but the colors still look like every other chart in the building? That's the default Excel problem. The chart formatting works. The numbers are right. But the color scheme is whatever Microsoft chose, which communicates "I built this in ten minutes and didn't think about it." After fifteen years building dashboards for VP- and board-level audiences at a financial services firm, I can tell you that chart colors in Excel are the first thing executives read and the thing they remember longest. Before you touch a single data series color, make one commitment: every color choice has a reason. Not "I liked it." A reason.

This guide walks through three steps: applying a theme, setting exact colors with hex codes, and locking consistency across a full workbook. If you already have a chart inserted, you're ready to start. If you don't, creating a chart in Excel takes about two minutes before you come back here.

Excel dashboard showing consistent chart colors using a teal and charcoal palette across bar and line charts
Consistent color across every chart is the difference between a dashboard and a collection of charts.

Step 1: Apply an Office Theme or Built-In Color Palette to Your Excel Chart in Seconds

How to Switch the Chart Color Scheme from the Chart Design Tab

Click your chart once to select it. You'll see the Chart Design tab appear in the ribbon — that's your starting point for any color scheme change. From there, two options are worth knowing:

  1. Click Change Colors (left side of the ribbon) to pick from a row of built-in color palettes. These are grouped into "Colorful" and "Monochromatic" sets.
  2. Or use the Chart Styles gallery (the larger panel to the right) to apply a full style: background, gridlines, and color together.

Either one updates every data series in the chart instantly. For most situations, a monochromatic palette is the cleaner professional choice. One color, multiple shades. It reads as intentional.

When to Use Theme Colors vs. Standard Colors

This is where most people make a mistake they don't notice until later. Excel offers two color types in every color picker: Theme Colors and Standard Colors. Theme colors are tied to the active Office Theme — if the theme changes, they update automatically. Standard colors are hardcoded and won't shift.

Using Standard Colors instead of Theme Colors can break your dashboard the moment someone opens the file under a different Office Theme. Use theme colors wherever possible, and only drop to custom hex codes when you need a specific brand match (covered in Step 2).

Step 2: Set Exact Chart Colors in Excel Using Hex Codes or the Windows Color Picker

How to Enter a Hex Code to Match Brand Colors on Any Data Series

Once you've applied a base palette, this is where real brand color matching happens. Double-click directly on a data series in your chart (not a single click, a double-click) to open the Format Data Series pane on the right. Navigate to the paint bucket icon, click Fill, select Solid fill, then click the color dropdown and choose More Colors. In the dialog that opens, click the Custom tab. You'll see a hex input field at the bottom.

Type your hex color code directly. No hashtag needed — Excel handles that. A strong professional accent is #2C8C99, a teal that reads as calm and directional without alarming the reader the way a saturated blue or red does. Paired against charcoal (#333333) and white, it looks deliberately designed rather than default.

The precision matters more than people expect. The difference between #FF0000 and #C0392B is the difference between a report that alarms and a report that informs. Validating your palette at Coolors.co before committing takes five minutes and prevents a lot of bad calls.

The Windows Color Picker (the eyedropper icon in the same dialog) lets you sample a color directly from your screen, which is useful when you're matching a logo open on a slide behind Excel. In Microsoft 365, the eyedropper works across applications. In Excel 2019, keep it within the Excel window.

Step 3: Keep Chart Colors Consistent Across Every Chart in Your Workbook

Setting a perfect hex color on one chart doesn't help if the next chart uses a different blue. This is the dashboard consistency problem, and it's more common than it should be.

The fix is a custom Office Theme. Once you've finalized your palette on one chart, go to Page Layout → Themes → Save Current Theme. Name it something you'll recognize. From that point, any new chart in any workbook where you load that theme will inherit the same color scheme automatically. One setup, applied everywhere.

For situations where you need chart color by value — bars that turn red when a metric drops below target, for example — that's a job for conditional formatting, not manual data series color. Conditional formatting handles dynamic chart color based on data without VBA, and it belongs in its own workflow. The principle is the same: the color encodes a specific meaning, not just aesthetics.

If you're building out a full reporting system, the retail inventory visualization guide has practical examples of this layered approach.

Common Mistakes With Chart Colors in Excel

Three mistakes account for most of the chart formatting problems I see.

The first is using multiple colors on a single-series chart. If you've got one bar chart showing monthly revenue, every bar represents the same measure — different colors imply the colors mean something. They don't. One color tells a cleaner story.

The second is the Standard Colors trap from Step 1. Set a color from the Standard row, share the file, and watch it look completely different on a colleague's machine with a different active theme. Confirm whether you're in theme territory or hardcoded territory before you finalize anything.

The third is ignoring contrast and accessibility. ColorBrewer was built specifically for this — it offers accessible color combinations that hold up for readers with color vision deficiency. If your color combinations aren't intentionally accessible, they're accidentally accessible. For anything going to a mixed audience, that's not a design decision; it's luck.

Color is not decoration. It's the first thing your reader sees and the last thing they remember. Choose it accordingly.

Frequently Asked Questions

How do I apply custom brand colors to an Excel chart using hex codes?

Double-click a data series to open the Format Data Series pane, go to Fill → Solid fill → More Colors, and select the Custom tab. Type your hex code directly into the field — no hashtag required. This works in both Microsoft 365 and Excel 2019.

Why do my Excel chart colors look different on another computer after sharing the file?

This almost always happens when colors were set using the Standard Colors row instead of Theme Colors. Standard colors are hardcoded, but they can render differently depending on the active Office Theme on the other machine. Use theme-based colors or explicitly set hex codes via the Custom tab to avoid this.

When should you avoid using multiple colors in an Excel chart?

Avoid multiple colors on any single-series chart. If every bar in a bar chart represents the same type of data, different colors imply a distinction that doesn't exist. Multiple colors are only justified when color encodes a specific meaning, like category differences or performance thresholds.

How do I keep chart colors consistent across multiple charts in an Excel workbook?

Save a custom Office Theme after finalizing your palette: Page Layout → Themes → Save Current Theme. Any workbook where you load that theme will apply the same color scheme to new charts automatically. This is the fastest path to dashboard color consistency without manually reformatting every chart.