Excel Charts with Data Tables

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
 
G

Gord Dibben

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
 
Top