Excel Charts with Data Tables

  • Thread starter Thread starter Joe R @ AA
  • Start date Start date
J

Joe R @ AA

Need your help!
I'm creating charts to plot YOY and MTD comparisons of data. My charts'
data tables keep populating future months with zeroes even though the
reference data cells are blank. How can I get just the future months cells
to be blank and not show zeroes?

Regards, Joe
 
Adjust to suit but the basics are to trap for a blank cell and return a
blank if one is found.

=IF(A1="","",A1)

=IF(AND(A1="",(A2="")),"",A1+A2)


Gord Dibben MS Excel MVP
 
Back
Top