Hi Karen,
What version are you using? In the Chart Expert (Insert>Chart) you should see an advanced button under the Layout header. Click it and you will be able to select the fields required.
I have noit been able to recreate you problem but I have attached some docs that may help. If they...