Chart legend & x-axis Title in Report 1

[nastar1]

I have created a simple chart within a report using the chart wizard.

The basis is a relationship of open 'jobs' from a job table and category from a category table.

The category table is made up on a CatID (autonumber) and Category description.

The data displays properly, however both the legend and X-axis uses the CatID rather than the Category description.

Is there a way I can create this chart in a report where it will use the Category description rather than the CatID?

Thanks

 

[GingerR]

Alter the rowsource of your chart. In the report design, look at the properties of the chart. In the Row Source property, click the build button to the right (the little button with the three dots on it) and alter your query to show the Category Desc instead of the Cat ID.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[nastar1]

Thanks GingerR,

That was just the clue I needed. The Category Desc was not in the 'build' area of the Rowsource, but I discovered that this was simply because my underlying query didnot include the Category table with its Category Desc field and the relationship to the 'Jobs' table. Once this 2nd table was added, I was able to find the Category Desc in the Rowsource.

Thanks again. It was your suggestion that got my problem solved.