Empty Cells & Charts

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

Guest

How do I get data ranage with blank cell into a chart and have Charts to
treat Empty Cells as nothing (NULL) rather than as 0's??
 
Leroy -

This is not an empty cell:

=IF(A>B,"",A-B)

The cell contains "", which looks blank, but isn't. Replace "" with NA(), which puts
an ugly error in the cell, but is interpolated over by the chart. Hide the error
with conditional formatting, as explained by Deb Dalgleish:

http://contextures.com/xlCondFormat03.html#Errors

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart displaying "blank" cells? 13
Chart SERIES OFFSET 3
How to create a bubble chart with more than 2 variables 0
Remove Space on Bar Charts for Missing Data 2
How do I stop chart from plotting null values as zeros in excel 20 3
MS Excel does not interpolate empty cells 3
Is it possible to define a null value (a la -999.25)? 1
Auto set data ranges 2

Back
Top