Expand the ‘Border’ option and you’ll see another, very similar menu that applies to the borders of the bars. In terms of colours, you can easily adjust borders of the chart bars, too. 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!Īnd there’s one more thing worth knowing about. Let’s click on the June bar, for example, and change the green to this dark red. 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. To use a different colour for each bar, select the option ‘Vary colors by point’. What’s amazing about this is that you’re not limited to use just one colour for all bars. How to Use a Different Colour for Each Bar Let’s select this bright red and click on OK.Įxcel will promptly change the bars colour to the one we’ve chosen. Here you can mix any colour you need or you can define an exact colour using an RGB or a HEX code. If this is not enough of a choice, you can use the option ‘More Colors’ at the bottom.

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 a Colour Fill for the BarsĮxpand ‘Fill’ and the menu that appears offers several options you can apply, like ‘No fill’, ‘Solid fill’ or ‘Gradient fill’ among many others.

Let’s have a look at both options one by one. Here you can choose a colour fill for the bars as well as the border type. In this tutorial, we’re going to cover only how to change chart colour, so click on the option Fill & Line.

On our right, we can see a pane with various options to format data series. To change chart colour, first we double-click on any bar in the chart. 3 How to Adjust Borders of the Chart Bars

How to histogram chart excel 2013