line graph problem - not showing lines if only one record - can anyone

[scouser]

hi there

I have a graph which has a bar graph and a line graph overlaying it.

If there is more than one record in the query, the lines of the line graph show. However, when there is only one record in the query, the line graph no longer shows, but the underlying bar graph still shows. Does anyone one know why this is happening?

TIA

Shirley

 

[MarkSweetland]

You'll probably have to set the graph Scale to always include zero. It might be your trying to graph the line series based on one point and not the difference beteen two points.

Mark

 

[scouser]

Thanks for your help Mark. My graph does go through from 0 to 100 if that is what you mean ? However, I have since discovered that Crystal Reports requires two points to produce a line. So, maybe that it is why the line does appear when there is only one record...

Shirley

 

[MarkSweetland]

I think so. The scale may go from 0 to 100 but you'll have to always include zero as a data point in the series to get a line from the bottom left of the graph to the first 'real' data point.

Mark

 

[scouser]

Thanks Mark, still can't get it to work though!