how to change X axis name

[naythway]

Hello,


I have a problem when i create a pivot table . X axis and Y axis is show the number of ID (Primary key value) instead of owner name. How can i change this ? I high light with red rectangle . I want name there , not number ( this number come from table primary key).

Thanks..

[June7]

By pivot table, do you mean a CROSSTAB query? And then this is a chart control using the query as RowSource?

Options.

1. Include the table that has the owner name in the dataset that the pivot (CROSSTAB?) is based on

2. join CROSSTAB query to the table with owner name