Lines not showing up on Line graph

[JosephRoy]

Help,

I have created a line graph and I am having a problem. All the data points show up correctly, but the lines aren't displaying. The crosstab query has this format:

Start_Date L1 L2 L3
09/02/03 500
09/03/03 600
09/06/03 575
09/09/03 650
09/10/03 620
09/16/03 700
09/17/03 580
09/20/03 600
.
.
.

What I want to do is display a line between the values in each of the columns, but because the data is not continuous, only the value points show up. How would I go about getting this to work the way I want?

Thanks.

 

[SkipVought]

Joe,

Seelct you chart and then Tools/Options and see if there's an option for the chart to plot empty cells as interpolated.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[JosephRoy]

Thanks, that worked great. Now that I see the lines on my chart, I find another problem. I have several zero values that I would like to handle the same as the blank cells. Is there any way to supress the zero values, or will I have to somehow modify the underlying query?