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
 
Ad

Advertisements

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top