Excel 2000. I have two series plotted on a graph. The 1st is a bar
graph containing values for six years, 1999-2004. The 2nd is a line
graph having values for only two years, 2003-2004. As is, the 2nd
series is plotted in the first two x-values positions of 1999-2000,
which is incorrect. To correct this, I dummied the 2nd series to have
4 empty cells at the start so that the 2003 and 2004 values for each
series show on the same point on the x axis. However, for those 4
dummied years the line graph shows "0" and plots a line at 0. I would
prefer not to see the line in years 1999-2002 at all. Any solution to
this?