One more try. Are you using the chart wizard? Can you right click on the chart and select "chart object" then edit. Then you can manipulate fields, etc., by right clicking. Still open to you emailing me the database. The charts are a little tricky.
Beth beth@integratedresourcemgmt.com