I created a basic line graph in Excel with 3 data series, across a period of time. The problem is that data isn't available for ONE of the time periods for ONE of the data series (the cell is NULL) ... causing my line in the graph to dip straight down to the X-axis. I do not want this dip to show.
Is there a way to have the chart wizard IGNORE that NULL cell and remove that errant line from the data series?
Attached is a screenshot to help you understand better...