Plot blanks on a graph

[Pauljj]

Hi there everyone.

I have a graph that occasionally I want to plot a blank on a line graph. I currently do this by forcing a #NA error using the formula NA() This appears perfectly on my graph but when I sent it to other users they don't see the blanks. They see a continuous line

I have deduced I may have a Office 365 and the others I send to, do not. So this may be the root cause

My thought was then to write this into visual basic

ActiveChart.DisplayValueNotAvailableAsBlank = True

But rather then apply this to just the active chart, how can I apply this to all graphs in the workbook ?

Thanks
Paul

 

[Pauljj]

Any ideas?