Change the invert if negative colour in Excel charts

In charts it is useful to change the colour of the chart if a series goes negative. This is done easily in Excel, but the problem is that it may not look like you have a choice of what that colour is. So how do you change the ‘Invert if negative’ colour in Excel?

Invert if negative in Excel charts

As shown below if you want to invert any part of a chart series that goes negative to another colour, you would

  • Double click on the series to get the chart dialogue boxes
  • Choose the Fill option
  • Click on the ‘Invert if negative’ tick box
invert if negative colour in excel

Note that the series items turns white and you don’t seem to be able to change this. Note as well that the Fill setting is the Automatic option (red box- this is important)

‘Invert if negative’ colour options in Excel

If you want to change the colour for the negative series items, you need to get off the Automatic option as this hides the colour options.

So to change the ‘Invert if negative’ colour options in Excel

  1. Double click the series to activate the Series dialogue options

  2. Change the colour option to be ‘Fill with Solid Colour’ (step 1 below)

  3. Now tick the ‘invert if negative’ option box (step 2)

  4. A new fill button appears which is where you choose the colour you want for negative numbers (step 3)

invert if negative colour in excel

Related

Change more than 6 default chart colours

Excel Chart sizes are different when printed and viewed on screen

MS Excel axis labels overlap in charts (what can you do about it)

Excel Charting course

Excel negative numbers

Excel waterfall chart template