Access 2003 Chart - Wrong Y Axis Labels

[Billow]

I use the following query, as the row source for a chart on an Access
Report. The Query definition is modified on the report Open event to
modify the date range:

SELECT dbo_tblPerfStatsSummary.myDate, 100*([CatA8mins]/[CatACalls]) AS
Performance, 75 AS Target
FROM dbo_tblPerfStatsSummary
WHERE (((dbo_tblPerfStatsSummary.myDate) Between #10/9/2006# And
#11/9/2006#));

'Performance' is displayed as a vertical bar chart and
'Target' is displayed as a line graph, both on primary axis.

This has worked perfectly well in Access XP and Access 2003, except one
machine running Access 2003, where the Y axis seems to be displaying
negative values from an unknown source.

I have checked the axis settings and all appear to be identical to
correctly working versions. When I open the chart object, the date
table contains the expected data.

I have several, very similar charts on the report and all of them have
the same problem.

Has anyone else experienced a similar problem, and found a solution?

 

[Billow]

I use the following query, as the row source for a chart on an Access
Report. The Query definition is modified on the report Open event to
modify the date range:

SELECT dbo_tblPerfStatsSummary.myDate, 100*([CatA8mins]/[CatACalls]) AS
Performance, 75 AS Target
FROM dbo_tblPerfStatsSummary
WHERE (((dbo_tblPerfStatsSummary.myDate) Between #10/9/2006# And
#11/9/2006#));

'Performance' is displayed as a vertical bar chart and
'Target' is displayed as a line graph, both on primary axis.

This has worked perfectly well in Access XP and Access 2003, except one
machine running Access 2003, where the Y axis seems to be displaying
negative values from an unknown source.

I have checked the axis settings and all appear to be identical to
correctly working versions. When I open the chart object, the date
table contains the expected data.

I have several, very similar charts on the report and all of them have
the same problem.

Has anyone else experienced a similar problem, and found a solution?

Further to the above...

A reinstall of Office 2003 sorted it out and the charts now display
correct values.

It might have been something to do with Access 2007 Beta being
installed on the same machine.