|
Excel Charts with Data Tables
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 |
Excel Charts with Data Tables
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 On Tue, 14 Apr 2009 08:20:04 -0700, Joe R @ AA wrote: 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 |
| All times are GMT +1. The time now is 04:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com