Make Chart Control on Report change from Record to Record

[maxx429]

Hi all,

I am posting this question for a co-worker. She knows very little about Access but has been asked to create some reports. One the requirements is that the report contain a Pie Chart showing a breakdown of Costs as a percentage of Total Income for each Job.

I thought this would be relatively simple. Create a query where each record was for an individual job with associated costs and Total Income. Create a report based on that query and insert a Chart control set to change data with each Job #.

Well, it's not working quite the way I had envisioned. I cannot seem to figure out how to specify the 'Whole' and the 'Part' portions of the chart.

In other words, how do I configure the Chart control to know that Total Income is the totality of the pie and that various other Costs are the pieces of the pie that I want percentages on?

I apologize if this is clear as mud. I have never used Charts in any of my other forays into Access and cannot find anything helpful in the various texts I own. Please feel free to ask any clarifying questions and I'll do my best to explain. I''m sure I'm probably missing something simple since I cannot imagine that I'm the first person that's wanted a Pie chart to break down percentage of Costs to Total Income. But for the life of me, I can't figure out what I'm doing wrong.

Thanks for looking.

Garrett