Hello,
I have a chart which includes blank cells for the series data of the line. I'd like the chart to ignore the blanks completely - as you can see, it currently pots those blank cells at zero:
The formula I have in the blank cells is
I'd like the chart only to plot data that is not blank. Any ideas please?
Thank you!
I have a chart which includes blank cells for the series data of the line. I'd like the chart to ignore the blanks completely - as you can see, it currently pots those blank cells at zero:
The formula I have in the blank cells is
Code:
=IF(L17<>"",IFERROR(N17/J17,"0%"),"")
I'd like the chart only to plot data that is not blank. Any ideas please?
Thank you!