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:
The Y axis (# of pellets) is nothing special.
I entered blank rows, corresponding to the missing
months, into the
datasheet, like so:
This "method" plots the data points okay, but there are
(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
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