View Single Post
  #1  
Old April 13th, 2009, 07:10 PM posted to microsoft.public.excel.worksheet.functions
Joe R @ AA[_2_]
external usenet poster
 
Posts: 5
Default Chart Data Table

On a YTD Chart, I need the data table to show blanks, not zeroes for future
months.
The data sheet which the chart references for the numbers are blank. The
cell formula uses "" if the current month is less then the month for that
column. How do I blank out the zeroes?