How To Delete Data Points In Excel
vii Answers 7
Really if you are going to use SpyJournal'southward answer it has to be =IF(b2=0,NA(),b2), otherwise Excel just recognizes it as text, not as an 'official' #North/A
answered Jan 23, 2009 at two:xxx
"Depict it to the teddy bear" works almost every time...
You lot have to become to the Border child object of the Point object and set up its LineStyle to xlNone.
answered Sep ten, 2008 at 9:56
d91-jald91-jal
997 2 gold badges 11 silver badges 18 bronze badges
Equally a general tip: If you know how to do something in excel, but don't know how to do information technology in VBA you could just record a macro and look at the recorded VBA-code (works at least most of the time)
answered Sep x, 2008 at x:03
sdfxsdfx
21.4k 4 aureate badges 24 silver badges 34 statuary badges
1
There is a Non VBA solution as well that tin can also be controlled from the VBA code as well. In excel a data point represented by a #North/A volition non display. Thus y'all tin can use a formula - the easiest is an IF office - that returns an #N/A 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 information technology.
An example is merely to generate your graph information in a table, and so replicate information technology below with a formula that only does this
=If(B2=0,"#N/A",B2)
This works when you want to stop line charts from displaying 0 values for example.
answered Sep xv, 2008 at 22:33
SpyJournalSpyJournal
289 1 gilt bluecoat two silver badges viii bronze badges
This is probably besides late to be of assist merely the answer past SpyJournal, whilst like shooting fish in a barrel and elegant,is slightly incorrect every bit it is necessary to omit the quotes around #N/A
answered Dec 2, 2008 at 17:12
Yes. It doesn't take to have the quotes to exist a true not bachelor cell content but for me Northward/A however plot equally 0 in my charts.
The only fashion I tin get it not to plot is to have the cell blank.
answered Dec 6, 2012 at xi:xv
I tried "#N/A" with quotes in Excel 207 and as a event the data bespeak is shown similar a zero in the graph. It Works without the quotes.
answered Jul 1, 2015 at ii:09
Not the answer y'all're looking for? Scan other questions tagged excel charts vba or ask your own question.
How To Delete Data Points In Excel,
Source: https://stackoverflow.com/questions/53719/hiding-data-points-in-excel-line-charts
Posted by: bennettweland.blogspot.com
This wont work properly in Excel 2007, due to lack of back up for macro recorder and charting engine.
Oct 18, 2010 at 21:32