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 unable to click the box under Hidden and Empty Cell Settings that says Connect Points with Line instead of the Zero options. Please help!
Libby Working
2 Replies
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
Can you post the data? Or an example of it to have a look at?
