How to Change Chart Colour in Excel

How to Change Chart Color in Excel

Today we’re gonna talk about how to change chart colour in Excel. This can be especially helpful if you need the colour of the bars in a chart to match your presentation theme, but also any time you need to use a colour different from the default one.

Ready to start?

Would you rather watch this tutorial? Click the play button below!

To change chart colour, first we double-click on any bar in the chart.

How to Change Chart Colour in Excel - double-click on any bar in the chart

On our right, we can see a pane with various options to format data series.

How to Change Chart Colour in Excel - Format Data Series

In this tutorial, we’re going to cover only how to change chart colour, so click on the option Fill & Line.

How to Change Chart Colour in Excel -Chart Color

Here you can choose a colour fill for the bars as well as the border type.

How to Change Chart Colour in Excel - Color fill and border type

Let’s have a look at both options one by one.

How to Change a Colour Fill for the Bars

Expand ‘Fill’ and the menu that appears offers several options you can apply, like ‘No fill’, ‘Solid fill’ or ‘Gradient fill’ among many others.

How to Change Chart Colour in Excel - Color fill options

To change the default blue in all the chart bars, click on the icon next to ‘Colour’ and choose any of the pre-defined, standard colours offered here.

How to Change Chart Colour in Excel - Pre-defined standard colours

If this is not enough of a choice, you can use the option ‘More Colors’ at the bottom. Here you can mix any colour you need or you can define an exact colour using an RGB or a HEX code.

How to Change Chart Colour in Excel - Option - More Colors
How to Change Chart Colour in Excel - RGB and HEX code

Let’s select this bright red and click on OK.

How to Change Chart Colour in Excel - Selected Bright Red

Excel will promptly change the bars colour to the one we’ve chosen.

How to Change Chart Colour in Excel - Red Color Chart

How to Use a Different Colour for Each Bar

What’s amazing about this is that you’re not limited to use just one colour for all bars. To use a different colour for each bar, select the option ‘Vary colors by point’. Every bar in the chart now has its own colour fill and every single one can now be adjusted the way we saw a while ago.

How to Change Chart Colour in Excel - Option - Vary Colors by point

Let’s click on the June bar, for example, and change the green to this dark red.

How to Change Chart Colour in Excel - Changing green to red
How to Change Chart Colour in Excel - Changing green bar to red
How to Change Chart Colour in Excel - Red Bar

If you decide to return to only one colour for all the bars, simply unselect ‘Vary colors by point’ and that’s it! The chart’s back to one colour only!

How to Change Chart Colour in Excel - Unselect the Vary colors by point
How to Change Chart Colour in Excel - one colour for all the bars

And there’s one more thing worth knowing about.

How to Adjust Borders of the Chart Bars

In terms of colours, you can easily adjust borders of the chart bars, too. Expand the ‘Border’ option and you’ll see another, very similar menu that applies to the borders of the bars.

How to Change Chart Colour in Excel - How to adjust border

Let’s select ‘Solid line’ here and change the blue colour of the borders of the June bar to – let’s say – red.

How to Change Chart Colour in Excel - Option - Solid line
How to Change Chart Colour in Excel - Select red color
How to Change Chart Colour in Excel - Red Border

Here we go!

As soon as you’ve finished formatting the bar chart, simply close the pane by clicking on the X in the upper right corner.

How to Change Chart Colour in Excel - close the pane

There are a lot of great things you can do with your charts!

If you’re interested to see how you can format other elements in the chart, check out the links to more tutorials by EasyClick Academy! You’ll find them in the list below!

Don’t miss out a great opportunity to learn:

If you found this tutorial helpful, give us a like and watch other video tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!

Thanks for watching and I’ll see you in the next tutorial!

Comments

Add comment

Your email address will not be published.

Your personal information will only be used for the purpose of processing this comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.