Thread: how do I get the if function to return a blank cell, not 0?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
JoeCars JoeCars is offline
external usenet poster
  
Posts: 2
Default how do I get the if function to return a blank cell, not 0?
I am trying to create a chart from a series that contains data for each
month. The series is calculated on other worksheets and copied to the
worksheet containing the chart. I would like to have the cells for the
months that have not been updated yet (now is January, there are 0' in all
cells for Feb-Dec) to be blank (to create gaps in the chart) not 0's.
Can this be done?
Reply With QuoteReply With Quote