Trouble with Simple Pie Chart

I'm creating a monthly report for each of our parishes. The report needs to
have a simple pie chart with two slices - one that shows the percentage they
have collected toward their annual fund goal and one that shows the remaining
percentage to be collected.

I have used the chart wizard multiple times, trying to create the chart
using fields in the report or fields in a query. I'm using the parish id
field as Master/Child link fields everytime I attempt to create the chart. I
keep get slices labeled east, west, north and columns that represent the
quarter. Clearly, this is some sort of sample data and I can't seem to get
it to look at the numbers i need it to look at.

This should be the simplest of charts and I can't seem to make it work. All
advice will be welcome.

You are seeing the horrible sample data in the chart datasheet. You can copy
and paste your own data in there if you want.

Any chart control will display the values from the Chart's Row Source
property. You can set the Link Master/Child property of the chart to filter
the chart's data. This is very much like setting similar properties for
subforms or subreports.
--
Duane Hookom
Microsoft Access MVP


"RKEvans" wrote:

I'm creating a monthly report for each of our parishes. The report needs to
have a simple pie chart with two slices - one that shows the percentage they
have collected toward their annual fund goal and one that shows the remaining
percentage to be collected.

I have used the chart wizard multiple times, trying to create the chart
using fields in the report or fields in a query. I'm using the parish id
field as Master/Child link fields everytime I attempt to create the chart. I
keep get slices labeled east, west, north and columns that represent the
quarter. Clearly, this is some sort of sample data and I can't seem to get
it to look at the numbers i need it to look at.

This should be the simplest of charts and I can't seem to make it work. All
advice will be welcome.