Excel 2016 interpolating between NA in plot even after selecting Show Empty Cells as: Gaps

Hi,

 

I had several plots where I had chosen the option "Show Empty Cells as: Gaps" and it was working great:

 

However, today I re-opened the file, and it looked like this:

 

 

I checked, and the option was still active:

 

 

I have no idea why this is happening and it has been an incredible waste of time!

 

I researched a little more about it, and in that same Hidden and Empty Cell Settings window, there should be an additional option that says Show #N/A as an empty cell (See step 5 here: https://support.office.com/en-us/article/display-empty-cells-null-n-a-values-and-hidden-worksheet-data-in-a-chart-a1ee6f0c-192f-4248-abeb-9ca49cb92274?NS=EXCEL&Version=16&SysLcid=1033&UiLcid=1033&AppVer=ZXL160&HelpId=90807&ui=en-US&rs=en-US&ad=US).

 

However, as you can see in the image above, that option does not appear for me.

 

Can someone please help me to fix this? I am also attaching an example spreadsheet that has the issue.

 

Thanks!