First post from a "casual" Excel user (more familiar with SigmaPlot)...

Client wants a line chart with x-axis linear (baeline to 36 months) but
there are only data for 2 baseline conditions and certain months:
on-drug
off-drug
M3
M6
M12
M24
M36

The Y axis (# of pellets) is nothing special.

I entered blank rows, corresponding to the missing months, into the
datasheet, like so:
on-drug
off-drug


M3


M6





M12 (etc.)

This "method" plots the data points okay, but there are 2 problems:
(a) there are no lines connecting them, and
(b) the x-axis labels are lousy

I worked around "b" by manually adding text boxes instead of x-axis labels,
but the missing lines problem is a major pain (I manually added lines, but
sometimes they don't hit the data points on center, and any resizing is a
bear!).

Is there a better way for Excel to deal with missing data and draw the lines
automatically, as it does if there are no empty rows in my datasheet?

Any help appreciated. Sorry for the length, but I figured it's better to be
specific.

Thanx