Hi,
I have a column of data that I want to display as a chart. However, there are some blank cells in the column. When I use a simple line chart, the chart drops the line all the way down to zero for the blank cells.
If the blank cell is B4 in column B, is it possible to make excel ignore that cell and connect B3 and B5 with a straight line?
Bookmarks