Crystal 10: Suppress Zero value on Chart

[Jenniefrances]

In Crystal 10, I have a line graph and I do not want it to plot a line where the data value is zero, ie we might not have data for that month yet. My group axis is months. I tried to right click on the chart and select Chart Options/Grid/Scales and uncheck the 'Always include zero box', but that does not seem to work. I saw on the Crystal Forum that this was a bug in Crystal 8 and 9.
I managed to overcome the prob by setting the min value of the scale as 0.01 and not dispaying out of scale values on the chart, but is there any other way of doing this ?

 

[huggyd]

if you do not yet have a value for a month then the value should be null. Null values are not mapped on the graph even though the month will be shown on the axis

Check how nulls are handled by your report though, as this may influence the way nulls are displayed