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
 

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

Similar Threads

create blank/empty cell - don't want a zero to be plotted in chart 6
Charts don't copy with new sheet 9
Copying Charts and graphs to another worksheet with formulas 1
Presenting all months in a year in a Pivot Table/Chart when allmonths are not included in source dat 0
set cell to empty 1
How not to chart zero value fields 1
Generating blank cells in Excel 2007 1
Trailing 30 days sum calculation with excel 1

Top