I currently have a chart for complaints & returns, however, future days/months are coming up zero on the chart.
Formula in use for cells is (one example): =COUNTIF(COMPLAINTS.xlsx!$A$2:$A$24,"3/25/2013")
Is there anything else I can add/use to omit these future zeros from showing on the line graph?
Thanks!
Bookmarks