01
Executive, finance, and general business reporting
Corporate Blue
It reads like a report, not a spaceship: a neutral page, one reliable focal blue, and no decorative rainbow.
Ready-made Excel color systems
8 Excel dashboard palettes
8 Excel dashboard palettes
+ 4 chart color sets
Pick the situation closest to yours and take the colors. You get eight complete dashboard themes, four sets for the data itself, exact HEX codes, applied previews, and Office themes you can load into Excel.
By Joshua Cottrell-Schloemer3× Microsoft Excel MVPExcel design specialist
Need a safe default?Corporate Blue
Ready-made answers
Download the Excel palette workbook ↓
Eight complete Excel dashboard palettes
Pick the situation closest to yours, copy the exact values, or download the Office theme. The previews use sample data to show the colors together. The .thmx file loads the canvas and text colors plus the six chart colors. Excel has no special status slots, so keep the positive/warning/negative values from the card for conditional formatting.
02
Sales, ecommerce, and operating dashboards
Warm Ecommerce
Mostly neutral, with one warm orange doing the pointing and calm meaning colors held in reserve.
03
Operational, healthcare, and service reporting
Operations Teal
Cool, calm supports keep the room steady while the status colors keep their one job.
04
People, sustainability, and planning reports
Forest + Paper
The page stays quiet and human; the forest green points, while the paper and charcoal do most of the work.
05
Strategy, people, and narrative-heavy reporting
Editorial Plum
A more editorial palette still spends its loudest color only where the story needs pointing.
06
Print-friendly operations and board packs
Boardroom Ink
Soft paper and ink read cleanly in a meeting, with one dark-enough accent that survives a copier.
07
Accessibility-first and projected reporting
High-Contrast Navy
Contrast is for the room, not your monitor: the hierarchy remains obvious from six feet away.
08
Screen-first product and presentation dashboards
Dark Screen
Near-black, never black; the neon belongs to the accents and marks, not the body copy.
Different job, different colors
Four color sets for the data itself
A complete dashboard theme controls the room. These smaller sets encode the data inside it. Do not use a status scale as a category palette or a heatmap scale for unrelated series.
Different things with no natural order
Six clear categories
Keep the mapping fixed everywhere. If you need more than six, group the small categories or highlight one against gray. The Color Studio will also check a set like this for color-vision safety before you commit to it.
Heatmaps, tables, and ordered quantities
Low → high
The shades get progressively darker. Keep that order consistent from low to high so the scale is easy to read.
Variance, change, and performance against plan
Below ↔ above
The midpoint must mean something (zero, target, plan, last year), not merely the middle of the data.
On track, watch, and off track
Status
Pair these with a check, dash, or X. Color should reinforce the label, never replace it.
What if my brand color is red or green?
You can still use it. The problem is giving the same color two conflicting meanings. If green identifies your brand and also means “good result”, make sure the reader can tell which job it is doing. Keep your brand color where it belongs, and use a separate, clearly labeled pair for good and bad results if needed. Blue and orange are one option.
Should a falling number always be red?
No. Fewer complaints, lower costs, or shorter waiting times might be exactly what you want. Decide what good and bad mean for each metric before assigning the colors. Add a label such as “Costs down 12%” so the reader knows what changed without having to interpret the color alone.
Working files
Want more help using color in Excel?
The Color Guide is my fast, practical intro to using color well in Excel reports, with swatches you can copy straight into your own workbook. It is $19 on its own. If you want a wider reference library, the Everything Bundle combines 30+ newsletter workbooks, the Dashboard Toolkit, and the Excel Theme Guide.
Think of color as a visual indicator to group ideas together. Choose a palette that fits your audience, keep the same categories the same color across charts, and check that text and neighboring series are easy to tell apart. One accent can be enough for a simple comparison. It is not a limit for every report.
The rule
Give your colors a job
The data viz world seems to have an aversion to color. It's treated like a distraction from the data, instead of an integral part of every design. Color helps establish a visual identity, grab attention, and group related information. If you have a metric in one color, keep that metric the same color in another visualization.
Start with your brand guide, a PowerPoint deck, or a visual reference that fits the audience. Choose a background, panel fills, text, and highlights, then work out how many categories your charts need to distinguish. A consistent design can be colorful. The test is whether someone can follow it, not whether you used fewer colors than the next person.
The palette
How to build it
01
Highlights and categories
Start with the brand colors. Use a highlight to draw attention, and choose distinct series colors if you need to compare several categories. Keep their meaning consistent across the report.
02
Backgrounds and text
For a light report, try a near-white background (#F7F8FA), light dividers (#E5E7EB), and dark text (#1F2A37). Panel fills take up a lot of the page, so choose those carefully: they set the overall feel.
03
Status, if you need it
If green (#2E9E6B) means good and red (#D1495B) means bad, keep that meaning consistent. Include labels or symbols as well. Not every report needs status colors.
04
Exact hex, every time
In any color picker choose More Colors → Custom, switch the model to Hex or RGB, and type the exact value. Same hex, same color, across the whole workbook.
Those values are a starting point for a light report, not a requirement. You might need a dark background or brighter panels to match the brand. Check the combination with actual labels and charts on it. Save your palette in Excel's theme slots, then apply that theme in each workbook. Existing charts using custom hex colors may need manual changes.
Need the palette to match your brand? The Data-Viz Color Studio turns a brand color, logo, website, even a PowerPoint into a complete system with every HEX value worked out. You get contrast and color-vision checks, a live chart preview, and one-click Excel and Power BI exports (plus CSS).
Readability
Contrast, dark, and light
Contrast is the whole game. Body text should clear its background comfortably, and your accent should be the highest-contrast element on the page - that's what makes it pull the eye. The fastest way I know to find a low-contrast problem is to squint at the sheet: anything that disappears needs to get darker or lighter.
Light dashboards are the safe default. They survive projectors, print, and fluorescent offices, and they leave you the most contrast headroom. Dark dashboards can look striking on a screen, but they're harder to get right: subtle grays collapse into each other and bright accents glow and bleed. If you go dark, use a near-black base rather than true black, raise your gray steps further apart, and desaturate the accent slightly so it doesn't vibrate. When in doubt, build light. You can see both handled well in the dashboard gallery and examples. The dark end of that is the neon dashboards file, where the accents do the glowing instead of the body copy.
The mistakes
What wrecks a palette
Colors that keep changing meaningRevenue is blue in the scorecard and orange in the chart. The reader has to relearn the same information. Keep the categories consistent.
Colors chosen without the reportA set of swatches can look great and fail when you put small labels and thin chart lines on it. Test the colors in the actual layout.
Low contrastLight gray text on a light gray fill looks elegant in your head and vanishes on a projector. Test by squinting.
Style that gets in the wayA colorful background can fit the brand and make the report more inviting. It becomes a problem when labels disappear into it or it competes with the information people need.
Red and green doing two jobsIf green also means "this category," it can't reliably mean "good." Keep semantic colors semantic.
Keep going
Related techniques
Match your slicers to the report
Apply the same colors to filter buttons and check the selected and unselected states.
Style the slicers →Create a custom Excel theme
Put the palette into Excel's theme slots so charts and reports inherit it.
Build the theme →Color Studio (free tool)
Generate a complete working palette from your brand color, logo, site, even a slide deck - with contrast and color-vision checks plus Excel and Power BI exports.
Open the tool →Dashboard fonts
Pair a display and body font so type carries hierarchy the way color carries emphasis.
Pick fonts →KPI card design
Where your green and red deltas actually live: on the metric tiles.
Build cards →Dashboard design principles
How color, layout, typography, and interaction work together.
Read the principles →The Excel Theme Guide
Turn your palette into theme colors, theme fonts, and a starter workbook you can reuse.
See the Theme Guide →FAQ
Dashboard color, answered
What colors should I use for an Excel dashboard?
Start with the brand or a visual reference that fits your audience. Choose background, panel, and readable text colors, then add highlights and distinct category colors for the charts. If a metric is blue in one view, keep it blue in the others. Use labels or symbols alongside status colors so color is not doing the explaining alone.
How do I enter a hex color in Excel?
Open any color dropdown (fill, font, or border), choose More Colors, then the Custom tab. Set the color model to Hex or RGB and type your exact value, for example 1F2A37. Excel stores it precisely, so the same hex gives the same color on every fill, which is how you keep a palette consistent across a workbook.
Should an Excel dashboard be dark or light?
Light dashboards are safer for print, projectors, and most offices, and they keep more contrast headroom. Dark dashboards can look striking on screen but are harder to get right because subtle grays collapse and bright accents glow. If you are unsure, build light, with a near-white background rather than pure white. See examples →
Why does my dashboard look like a rainbow?
Check whether colors mean the same thing across the page. A category that changes color from chart to chart makes the reader relearn it each time. Keep related information the same color, separate categories that need comparing, and remove competing fills where they make the labels or data hard to read. Several bright colors can work if the organization is clear.
How many colors should a dashboard use?
Count the jobs the colors need to do, not just the swatches. Backgrounds, panels, text, highlights, status, and chart categories have different roles. A single comparison may need one highlight; a chart with several categories needs distinguishable series colors. Excel themes provide six accent slots, but there is no universal three-to-five-color limit for a report.