MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Remove zero data labels on my Chart


Posted by Colleen on January 18, 2002 9:24 AM

Oh great and wise Excel Guru,

How can i remove the zero data labels without losing all the data labels for a set of values?

Thanks


Posted by Barrie Davidson on January 18, 2002 10:05 AM

Although I do not consider myself wise (I'm okay with the "great" part), here is my input. If I understand your question, try using a formula where you replace any zero data with the NA function. Excel will not graph #N/A values.

Hope this helps you out.
BarrieBarrie Davidson

Posted by Colleen on January 18, 2002 10:49 AM

Barrie the Great,
ok that makes sense...um any idea what such a formula might look like?

Posted by Barrie Davidson on January 18, 2002 1:41 PM

Colleen, you could use an IF statement. Something like:

=IF(A1=0,NA(),A1)

Does this help?
BarrieBarrie Davidson