<p>It is obviously possible to hide individual data points in an Excel line chart.</p>

<ul>
<li>Select a data point. </li>
<li>Right click -> Format Data Point... </li>
<li>Select Patterns</li>
<li>Tab Set Line to None</li>
</ul>

<p>How do you accomplish the same thing in VBA? Intuition tells me there should be a property on the <a href="http://msdn.microsoft.com/en-us/library/aa174283(office.11).aspx" rel="nofollow noreferrer">Point object</a> <code>Chart.SeriesCollection(&lt;index&gt;).Points(&lt;index&gt;</code> which deals with this...</p>

[{'answer_id': 53723, 'author': 'd91-jal', 'author_id': 5085, 'author_profile': 'https://Stackoverflow.com/users/5085', 'pm_score': 4, 'selected': True, 'text': '<p>"Describe it to the teddy bear" works almost every time...</p>\n\n<p>You have to go to the Border child object of the Point object and set its LineStyle to xlNone.</p>\n'}, {'answer_id': 53729, 'author': 'sdfx', 'author_id': 3445, 'author_profile': 'https://Stackoverflow.com/users/3445', 'pm_score': 2, 'selected': False, 'text': "<p>As a general tip: If you know how to do something in excel, but don't know how to do it in VBA you could just record a macro and look at the recorded VBA-code (works at least most of the time)</p>\n"}, {'answer_id': 67650, 'author': 'SpyJournal', 'author_id': 10326, 'author_profile': 'https://Stackoverflow.com/users/10326', 'pm_score': 2, 'selected': False, 'text': '<p>There is a Non VBA solution as well that can also be controlled from the VBA code as well.\nIn excel a data point represented by a #N/A will not display. Thus you can use a formula - the easiest is an <code>IF</code> function - that returns an <code>#N/A</code> as text in the graph data. This data point will then not display which means you don\'t need to try and manipulate the format for it.</p>\n\n<p>An example is simply to generate your graph data in a table, and then replicate it below with a formula that simply does this</p>\n\n<p><code>=If(B2=0,"#N/A",B2)</code></p>\n\n<p>This works when you want to stop line charts from displaying 0 values for example.</p>\n'}, {'answer_id': 334721, 'author': 'Community', 'author_id': -1, 'author_profile': 'https://Stackoverflow.com/users/-1', 'pm_score': 1, 'selected': False, 'text': '<p>This is probably too late to be of assistance but the answer by SpyJournal, whilst easy and elegant,is slightly incorrect as it is necessary to omit the quotes around #N/A</p>\n'}, {'answer_id': 471678, 'author': 'Community', 'author_id': -1, 'author_profile': 'https://Stackoverflow.com/users/-1', 'pm_score': 3, 'selected': False, 'text': "<p>Actually if you are going to use SpyJournal's answer it has to be <code>=IF(b2=0,NA(),b2)</code>, otherwise Excel just recognizes it as text, not as an 'official' <code>#N/A</code></p>\n"}, {'answer_id': 13742451, 'author': 'Garrydene', 'author_id': 1882137, 'author_profile': 'https://Stackoverflow.com/users/1882137', 'pm_score': 1, 'selected': False, 'text': "<p>Yes. It doesn't have to have the quotes to be a true not available cell content\nbut for me N/A still plot as 0 in my charts. </p>\n\n<p>The only way I can get it not to plot is to have the cell blank.</p>\n"}, {'answer_id': 31151493, 'author': 'Volker Piasta', 'author_id': 5067679, 'author_profile': 'https://Stackoverflow.com/users/5067679', 'pm_score': 0, 'selected': False, 'text': '<p>I tried "#N/A" with quotes in Excel 207 and as a result the data point is shown like a zero in the graph. It Works without the quotes.</p>\n'}]
['https://Stackoverflow.com/questions/53719', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/5085/']