Changing Bar Chart Colors Conditionally

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,
I have what I hope is not to difficult of a question. I have some code in my spreadsheet that uses the NA() function, which basically ignores whats in that cell, and that works fine. My question is if I turn on the Data Labels in my chart options to show the values on my chart it also shows #N/A. which isn't very appealing to the eye. Is there a way to say if value is equal to #N/A then show nothing?
Any help on this would be appreciated.

Thanks,
Lenny
 
Lenny -

You said Bar Chart in the title. As far as chart appearance is
concerned, #N/A and zero looks the same in the chart. So in this case,
use "" or zero in the formula instead of NA(). If you use zero, apply a
custom number format like this:

0.0;-0.0;;@

Number formats have four sections, used by default for positive,
negative, zero, and text values. In this format I've left out the format
for zero.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top