Hi, I have typed #N/A in cells where data was not available.
Now I want to pull a chart but I want the line chart to not show the missing data but show a continuous line.
I know it can be done but I can't recall exactly.
Thanks in advance.
Rebecca
Now I want to pull a chart but I want the line chart to not show the missing data but show a continuous line.
I know it can be done but I can't recall exactly.
Thanks in advance.
Rebecca