Trend Line must ignore periods not yet open

For both the Sales Summary and Purchase Summary graphical displays on the Turnover Bar Chart, the &trend& line should be calculated to ignore future (not yet open) financial periods. As it stands, the trend of all sales is always downwards until period 12 is &open& and has some figures. This is SO depressing!