Chart issues

[lehi53]

Everytime I try to create a pie chart it pulls the Id number into the legend rather than the name of the field. SO rather than showing me 3 are in Sold, and 2 are in Not sold, we get 3 are in 1(Id number), and 2 in 3 (ID number)

 

[jdraw]

Show some code that you have tried.

 

[lehi53]

I attached the database here. Look the form title chart to see what I am referring to. It keeps showing ID numbers.

 

[JHB]

Try by changing the charts "Row Source" to:

SELECT [level of hotness].Hotness, Count(*) AS [Count]
FROM [level of hotness] RIGHT JOIN [CG Info] ON [level of hotness].ID = [CG Info].Hotness
GROUP BY [level of hotness].Hotness;