Excel Bar Chart Different Color Bars: How to Set Them

Yes. In Excel for Microsoft 365 on Windows, select the chart, right-click a bar, choose Format Data Series, then open Fill & Line > Fill and select Vary colors by point to give the bars in one series different colors. To color just one bar, select that data point separately and change its fill.

How Excel assigns colors to chart bars

Excel charts organize plotted values into data series and data points. A series is a group of related values, and each individual bar represents one point in that series. For example, a chart showing monthly sales for one product has one series and one point for each month. A chart comparing sales for three products has three series, with each product represented by a separate set of points.

By default, Excel usually gives every point in a series the same color. When a chart contains multiple series, Excel assigns a different color to each series so readers can tell them apart. The Vary colors by point setting changes this behavior for a series: Excel gives its individual bars different colors. It is useful when each category matters on its own, such as showing sales by region or votes by candidate.

A bar chart uses horizontal bars; a column chart uses vertical ones. The same series and data-point color controls apply to both, so the instructions work for either orientation. If you only want to change the overall palette, rather than assign colors to particular values, use the chart color options instead.

Give every bar in one series a different color

Select the chart, then right-click one of the bars in the series you want to edit. Choose Format Data Series. If the right-click menu offers Format Data Point, you have selected an individual bar; click elsewhere on the series and try again.
In the Format Data Series pane, select Fill & Line, shown as a paint bucket, then expand Fill.
Select Vary colors by point. Excel applies different colors to the points in that series.

The colors come from the workbook’s chart color scheme. The setting does not assign permanent meanings to colors such as red for loss or green for profit. If a specific color must always represent a category, set the individual point colors yourself and check that the categories remain correctly identified.

To adjust the palette for the chart, select it and go to Chart Design > Change Colors. The available color sets depend on the workbook’s theme. This changes the chart’s color choices, but does not replace the need to choose a meaningful color strategy.

Color one bar without changing the others

For a one-off highlight, such as marking the best-performing month, format just that point. Click a bar once to select the series, then click the same bar again to select only that data point. The second click should be a normal separate click, not a double-click. Right-click the selected point and choose Format Data Point.

In the Format Data Point pane, open Fill & Line > Fill. Choose Solid fill, then select a color. You can also adjust the border under Border if a visible outline helps the bar stand out. Avoid changing the fill of the whole series by mistake: the pane heading should say Format Data Point, not Format Data Series.

For example, suppose the values are 12, 15, 11, and 22 for January through April. You could keep the first three bars in the same blue and color April orange to call attention to the maximum. Include a clear chart title or annotation explaining why April is highlighted; color alone does not tell readers whether the bar is a target, an exception, or simply the largest value.

Use separate series when colors have meaning

Vary colors by point is convenient, but it may not be the best design when each color represents a meaningful group. For instance, a chart with green bars for completed projects and gray bars for pending projects should encode those statuses consistently. If all projects are plotted as one series and Excel varies colors by point, the colors can appear arbitrary and may change when points are added or reordered.

In that case, arrange the source data as separate series, such as one series for completed projects and another for pending projects. Excel assigns a color to each series, and the legend can identify them. In a clustered chart, the series appear side by side for each category; in a stacked chart, they appear as segments of a combined bar. Choose a chart type that matches the comparison you want readers to make.

A simple rule is to use different colors for categories that need to be distinguished, and a consistent color for values in the same category. Use a single series with varied point colors for independent categories when the exact color is mainly visual. Use separate series when color carries a stable meaning that should be explained in a legend.

Choose colors that make the chart easier to read

More colors do not automatically make a chart clearer. A rainbow of similar hues can make adjacent bars hard to compare, and colors with low contrast may disappear against the chart background. Consider the chart’s purpose and viewing conditions before selecting a palette.

Use a restrained palette, especially when the chart has many categories. A single highlight color against neutral bars often communicates a key result more clearly than many competing colors.
Check contrast between the bars and the background, and between adjacent segments in stacked charts. Borders can help separate neighboring areas, but should not be so heavy that they dominate the data.
Do not rely on color alone to communicate a critical distinction. Add a legend, direct labels, or an explanatory note so the chart remains understandable when printed in grayscale or viewed by someone with color-vision differences.
Keep the meaning of a color consistent across related charts. If blue represents one region in one chart, using blue for a different region in the next can confuse readers.

Excel’s theme palettes provide coordinated color choices, but they cannot determine whether a palette is suitable for your audience. Preview the chart at the size it will be read, and consider how it looks on a light or dark background and in a printed copy.

What happens when the chart data changes

When new data points are added to a series with Vary colors by point enabled, Excel can apply colors from the chart palette to the new points. That means a color is not necessarily attached to a category’s name. If the source order changes, the color sequence can also change, and a category that was highlighted manually may no longer be the same point.

Manual point formatting is useful for a stable chart with a small number of categories. It takes more maintenance when the data is refreshed regularly, categories are sorted, or new categories appear. After updating the source data, check the chart and confirm that any emphasized bars still represent the intended values.

Excel charts do not automatically use worksheet conditional-formatting colors as their bar fills. Applying a conditional formatting rule to the source cells can change the cell appearance without making the corresponding chart bars follow those fills. If the chart must reflect changing rules, consider separate data series that represent the conditions, or use a charting approach designed around the categories you need to display. Verify the result after changing or refreshing the data.

Windows, Mac, and Excel for the web

The steps above use Microsoft 365 for Windows. In desktop Excel for Mac, select the series or point and open its formatting pane; the pane layout and ribbon arrangement can differ slightly from Windows, but the Fill controls are where you adjust the bar color. The chart’s context menu is another way to open the formatting controls.

Excel for the web supports common chart formatting, but some detailed formatting controls can be more limited or arranged differently than in desktop Excel. If you cannot find Vary colors by point or need precise point-level formatting, open the workbook in the desktop app and make the change there. The workbook can then be saved so the formatting is retained when it is viewed online.

Common problems and quick fixes

All bars changed together: You formatted the series rather than a single point. Select the bar once, then click that same bar again and confirm the pane says Format Data Point.
The bars still look alike: The chosen theme colors may be similar, or the chart may contain several series rather than one. Try Chart Design > Change Colors, or inspect each series separately.
The legend does not explain the colors: A legend identifies series, not necessarily individual points in a single series. Add data labels or a note, or restructure the data into separate series if the colors stand for distinct groups.
A color changed after sorting: The point order or series data changed. Review manual highlights after sorting, filtering, or refreshing the source.
Colors differ from the source cells: Chart point fills and worksheet cell formatting are separate. Set the chart colors directly or redesign the plotted series to represent the desired categories.

Frequently Asked Questions

Can every bar in an Excel chart have a different color?
Yes. Select the series, open Format Data Series, and turn on Vary colors by point under Fill. Excel assigns colors from the chart palette to the individual data points.

How do I change the color of only one bar in Excel?
Select the bar once to select its series, then select it again to select the individual point. Choose Format Data Point and set its fill under Fill & Line > Fill.

Why does Excel give all bars the same color?
That is the usual default for points in a single series. Enable Vary colors by point for multiple colors, or format an individual point manually if only one bar needs emphasis.

Can Excel automatically color bars based on their values?
Vary colors by point assigns palette colors to points; it does not apply a rule such as red below zero and green above zero. To represent value groups consistently, create separate series for those groups or format the points manually and review them whenever the data changes.

Does chart color formatting follow conditional formatting in cells?
No. Worksheet conditional formatting and chart point fills are separate formatting systems. A cell’s conditional-formatting color does not automatically become the matching bar’s color.

Does this work for a column chart too?
Yes. Bar and column charts use the same series and point formatting controls; the bars are simply oriented horizontally in a bar chart and vertically in a column chart.

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.