Excel 2003: How to remove line segment in chart
In previous version before 2003, I could select an individual point on a line series and disable that particular line segment. On one of my routine task, I use VBA to get this done in an automatic fashion.
In the 2003 excel, with the same sequence of actions, the line just skips the point and connects to the next point.
A way sort of get what I need is to use blank cell. But that generates a blank category on my x axis. Also many times the data contains formulas which I don't know how to return a blank in a cell. Excel seems treat na() differently from a true blank.
Does anyone know a smarter work around for this?