How to Make a Bar Chart Different Colors in Excel

A standard blue bar chart in Excel gets the job done, but it doesn't do much to grab your audience's attention or highlight key insights. Changing the colors of your bars is one of the quickest ways to make your data more intuitive and your reports more professional. This guide will walk you through a few different ways to customize your bar chart colors in Excel, from simple manual tweaks to powerful conditional formatting.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Bother with Different Bar Colors?

Color isn’t just for looks, it’s a powerful tool for visual storytelling. When you change the color of bars in your chart, you're adding another layer of information that helps your audience understand the data at a glance. You can use color to:

• Highlight a specific data point: Draw attention to a top-performing month, a product that's lagging behind, or the current period.
• Group related categories: Use similar shades to group categories, like different social media channels or paid ad campaigns.
• Show positive vs. negative: Use universally understood colors like green for growth and red for decline to instantly communicate performance.

A little-known fact is that Excel offers built-in ways to automate this, saving you from a tedious copy-paste process. Let’s look at three effective ways to get this done.

Method 1: Manually Coloring Individual Bars

This is the simplest and most common method. It's perfect when you only need to change a couple of bars to highlight something specific, like pointing out your best sales month in a quarterly review.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step-by-Step Instructions:

1. Create Your Bar Chart: If you don't already have one, select your data and go to the Insert tab. Choose your preferred bar chart from the Charts section. For this example, we’ll use a simple 2D Clustered Bar chart with monthly website traffic.

2. Select a Single Bar. This is the step where most people get tripped up.

• First, click on any of the bars in your chart. You'll notice that Excel selects all of them (you'll see selection dots on each bar).
• Now, click a second time on just the bar you want to recolor. This time, only that single bar will be selected. For instance, let's highlight our best month, June.

3. Change the Color. Right-click on the selected bar and choose Format Data Point… from the context menu. A new pane will appear on the right side of your screen.

• Click on the paint bucket icon (labeled Fill & Line).
• Under Fill, select Solid fill.
• Click the Color dropdown and pick your desired color. Let's make it a nice standout green.

That's it! Repeat the process for any other bars you want to manually change. It’s quick, easy, and great for one-off reports.

Method 2: Vary Colors by Point Automatically

What if you want every bar to have a different color? Manually changing each one would be a pain, especially if you have a lot of categories. Fortunately, Excel has a one-click setting for this.

This method is best when you're visualizing distinct, unrelated categories, like replies from social media platforms or sales from different employees.

Step-by-Step Instructions:

1. Select the Entire Data Series. Click once on any bar in your chart. Make sure all the bars are selected.

2. Open the Format pane. Right-click and choose Format Data Series….

3. Enable "Vary colors by point." In the Format Data Series pane, go to the paint bucket icon. Under the Fill section, you'll see a checkbox labeled "Vary colors by point." Check this box.

Instantly, Excel will assign a different color from its default palette to each bar in your chart. No manual coloring required!

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Method 3: Conditional Coloring Based on Rules

This is the most powerful and impressive technique. With this method, you can set up your chart so that the colors update automatically based on the data's value. For example, all bars above a certain goal can be green, while those below are red.

This sounds complicated, but it just requires a little bit of setup in your data table. Let’s say you have a sales team and you want to visualize which reps met their quarterly sales target of $50,000.

Step-by-Step Instructions:

1. Restructure Your Data. This is the key. You need to create some extra "helper" columns next to your original data. We'll use formulas to split your sales data into two groups: "Above Target" and "Below Target".

• Create two new column headers next to your sales data.
• Let’s assume sales figures are in column B, starting from B2.

2. Use the IF Formula. In the "Above Target" column (C2), enter this formula:

=IF(B2>=50000, B2, NA())

And in the "Below Target" column (D2), enter this formula:

=IF(B2<50000, B2, NA())

Drag these formulas down for all your reps. Here's a breakdown of what that formula does:

• It checks if the sales value in column B for that row meets the condition (e.g., is greater than or equal to $50,000).
• If the condition is true, it places the sales value in the current cell.
• If the condition is false, it enters NA(). This is important - NA() tells Excel to leave the cell blank in the chart instead of plotting a zero value, which would create ugly little stubs on your chart's baseline.

3. Create a Stacked Bar Chart. Now, instead of a regular bar chart, select your reps' names and your two new helper columns ("Above Target" and "Below Target"). Don't select the original sales column. Go to the Insert tab and select a Stacked Bar Chart.

Your chart will look a bit weird at first - like two separate charts on the same axis. Don't worry, that's what we’re about to fix.

4. Format the Data Series to Overlap. Here’s where the magic comes in.

• Right-click on any of the bars in your chart and choose Format Data Series…
• In the format pane, go to the chart icon (labeled Series Options).
• You will see an option for Series Overlap. Drag the slider all the way to 100%.

This tells Excel to place the two series directly on top of each other, making them appear as a single bar. Because your formulas ensure only one of the two columns can have a value for any given rep, you only see one colored segment per bar.

5. Set Your Colors. Now, you can simply change the color for each series.

• Click to select the "Above Target" series and set its fill color to green.
• Click to select the "Below Target" series and set its fill color to red.

Clean up your legend, add a chart title, and you're done! You now have a dynamic, self-coloring bar chart that instantly communicates performance.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Final Thoughts

Using colors in your Excel charts is a small change that makes a huge impact on readability and helps your team grasp insights far faster than scanning raw numbers. Whether you're making a quick manual tweak or setting up an automated conditional chart, these techniques can transform a plain report into a clear and compelling data story.

This process of setting up helper columns and formulas in Excel works well, but it highlights the manual effort often required to tell a clear story with your data. We built Graphed to bypass this entire workflow. Instead of using formulas and restructuring data tables, you can just connect your data sources (like Google Analytics, Salesforce, or even a Google Sheet) and ask a question in plain English, like "Show me monthly sales vs. target as a bar chart, and color sales above target in green," and have a real-time, shareable dashboard built for you instantly.