Graph Legend...ugghhh!!

[Dimples]

Ok, so I finally got my chart/graph in my report the way I want and I was so excited. However, now my legend is not appearing right. The legend is showing ID numbers as opposed to the titles for each category. When I view the chart in design view it shows the words (what I want). but when I view it in report view, it goes back to the the IDs(numbers). Anyone have any ideas of what in the world is going on with this and how to fix it. I want it to look on the report the way it looks in design view.

Help

 

[Dimples]

Really need help with legend

Ok, now...my legend is showing incorrectly in design mode as well as preview mode. It is showing the IDs where I want it to show the words/titles. The words/titles are the key in the table as well as the bound column so I am not sure why it is displaying the numbers. Does anyone have any ideas what is going on here. I have looked over this whole forum and cant seem to find the answer!!

Help!!

TIA!

 

[Rovers]

Have you tried giving the fields Aliases?

If you RClick to get chart properties (instead of double click to get the chart design) you can give Aliases in the record source line.

for example in Chart Properties - Row Source:

SELECT DISTINCTROW fld_Name AS Name FROM Qry_Customer GROUP BY fld_Name;

where you see the AS Name defines the Alias.

I think this is what you mean!

Try it.

 

[Dimples]

Thanks for the suggestion, but that still did not work. I still am only get the ID numbers and it is making me crazy b/c the words that I want are showing up in design view. I just can seem to get around this. I cant even use the chart if I cant show what they stand for.

 

[Rich]

Post the SQL of the underlying query