Hi All,
I am having a data sheet which I use as a base for calculations. In a seperate sheet, I reference to this data sheet or use formulas to deduct ratios. I furthermore display graphs over a timeline. See example attached.
The Issue that I now have is that even though there data sheet has empty cells for the time after may 2016 the references and calculations still show it as 0 and it is therefore plotted on the chart. Is there an Easy way to get rid of this 0?
Since I do have several worksheets linked I'd rather not enter a formula in each cell as this would take me ages.
Thanks a lot for your help in advance!!
Capture.PNG
Bookmarks