Chart auto-scale problem

[jcao0000]

I am creating a chart to compare the weekly number of 2006 and that of 2007. Values are shown as two curves in the chart. However, since the future weekly date is not available, it always show 0. The auto scale is not working properly because it always include zero values.
Is it possible to suppress the future date or any other solutions?
Thx.

 

[synapsevampire]

Do you mean dates beyond today as the future date?

You can filter those out in Report->Selection Formula->Record:

{table.date} > currentdate

-k