Forum Discussion
#N/A issues
Hello, I am attempting to make a line graph with markers using the #N/A formula. I need the values marked with #N/A to not drop to zero on the graph. I have tried the Select Data option and I am una...
Hi Libby,
Do you mean =NA() formula or you use "#N/A" text? In general if it's not generated by calculations you don't need it, you may use blank cells. And what do you see, like this
or "Connect data..." is in grey or you don't see it at all?
Just in case, more details is 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