logo
  • Excel Charts
  • About David Aldred & This Blog
  • Consulting & Excel Support

Highlight Negative Values on an Excel Chart

June 27, 2013 1 comment Article Easy, Excel, Microsoft Office
[Update: Be sure to check out the related article, Highlighting the Highest / Lowest Value on a Chart]

If you work with charts frequently, you may sometimes want any negative numbers to be coloured differently to the rest of the chart

Take this example, showing average temperatures for Prague


We may want to highlight Jan & Feb a different colour to highlight the fact its negative.

Whilst it has always been achievable, in Excel 2010, is a built-in option that it very easy. (2007 & 2003 had to use one of several workarounds)

Right-Click on the data-series, and select ‘Format Data Series’


Select the ‘Fill’ option, and change to ‘Solid Fill’. Change the main colour using the ‘Fill Color’ option, should you wish


 

Tick the ‘Invert if Negative’ box, and select a colour using the second paint bucket that has appeared.


Click ‘Close’, and that’s it! Your chart should now update!


As I mentioned, this is a feature of Excel 2010. The same effective can be achieved using 2003 & 2007, but is a little trickier – drop a comment if you want me to cover this off!

Related

Tags: Charts, Excel, Formatting

1 comment

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Format or Remove Borders from a Slicer or Timeline in Excel
Populate a table by looping through items in a list / another table
Showing Data Bars as a 'Proportion to Total' in Excel
Creating Virtual Tables in Power BI Using DAX
Using SUMPRODUCT to create a Conditional Weighted Average in Excel
Showing a Picture Based on the Value of another Cell in Excel

Meta

  • Register
  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

Categories

Pages

  • Excel Charts
  • About David Aldred & This Blog
  • Consulting & Excel Support

Copyright System Secrets 2022 - Theme by ThemeinProgress