In chart source range, set zero's to show NA() instead of "" or 0.
You will see N/A# in your table but they will not show or plot in the chart or chart table.
Use a formula similar to this…
Thanks so much for your help regarding this. I will proceed to follow what you said. It seems pretty straight forward. If I have any troubles I'm sure I'll have to ask you another question. But it seems okay.
If you typed in #N/A, or =NA(), XL should automatically draw a line through the missing data point. What is it doing now?
Alternatively, if you leave the cell blank (no formula, no text, no nothing), you have a choice of how XL treats missing data. Create the chart, then select the chart and select Tools | Options... | Chart tab. In the Active Chart section, set the 'Plot empty cells as' option to 'Interpolated'.
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.