Troubleshooting

Reversing the X-Axis and Legend Labels

After changing the Row Source property of a chart to the qry1997SalesChartCT crosstab query, the product categories appear in the chart as the x-axis labels, and the month abbreviations appear in the legend.

In the example in the "Assigning the Crosstab Query as the Graph's Row Source" section, you didn't change to Series in Rows in step 3. Crosstab queries you design can have the legend values (representing a series of lines) as column headers or row headers. If your x-axis and legend labels are wrong, activate the chart, choose Data, and then choose either Series in Columns or Series in Rows to make the change.

Connecting a PivotChart (Microsoft Office Chart 11.0) or PivotTable (Microsoft Office PivotTable 11.0) ActiveX Control

Using Insert Object to add a PivotChart or PivotTable ActiveX control to a form or report, and setting up the Microsoft.Jet.OLEDB.4.0 provider to connect to the current database results in a Data Link Error message.

When you have an Access object open in Design view, the Jet database is locked in the read-only state to prevent others from modifying objects simultaneously. The lock prevents opening the second connection to the database, which is required to support the ActiveX control version of these objects. This problem doesn't occur with ADP, because you can establish multiple simultaneous connections to SQL Server in Design view. The only advantage to the ActiveX control version of the PivotChart or PivotTable control, however, is that you don't need to add a subform to add design elements to the form. The downside is that your ADP requires additional connections to SQL Server to support each PivotChart or PivotTable.