I have made up a chart comparing two past years with the coming year. The past years obviously have entries in all data cells but the coming year doesn't. However, the coming year is taking its data from another sheet so there are formulas in the corresponding data source sheet cells. The formulas are like the following:
=IF('Sales 2019'!E11=0,NA(),'Sales 2019'!E11)
I did this as all the documentation online states that if the entry comes out as #N/A then it is ignored on the chart. However, as you can see from the attached, where there is no actual data (just the formula) in the cell then it is coming out as a flat line on the chart. I simply want to get rid of that flat line for any data that is not yet inputted.
Is there a way of doing this?
Chart_data_0.jpg
Bookmarks