DataBase - Pie Chart will only Display one slice - 100%

Asked By Peter

31-Jan-10 10:31 PM

I am having problems getting a simple pie chart graph to work within an
Access 2002 report.  The report is based on a query which has two calculated
fields - Male and Female.  The values within these fields come from a
separate function I developed to process records within a table in the
database and do a count for gender based on the Title field within each
record. (eg Mr, Mrs, Miss etc.)

The one page report simply prints out the above total values and within the
same detail section I tried to embed a pie chart graph to also represent
these values.  The chart displays only one slice with the Male value being
shown as 100% of the pie.

I have tried varying the SQL statement used in the Row Source for the
graph, but cannot get it to display the 2 slices that should make up the
whole.  (The Row Source is "SELECT [Male],[Female] FROM [qryGender];" ).

If I place the same data on an Excel spreadsheet with 2 columns - Male,
Female with total values placed in cells within a single row under these
headings, then insert a pie chart onto the spreadsheet, MS Graph has no
problem displaying the
correct pie chart.  What is it that is preventing this displaying correctly
in the Access report which is using the same data?   Do I need to further
refine the SQL?
--
Peter WA

31-Jan-10 11:32 PM

First, make sure you do not have anything in the link master/child properties.

If the above does not fix your chart, you can find the chart property for
Rows or Columns and maybe change it.

Then typically the data should be similar to:
Gender   Number
Male       34
Female   41

--
Duane Hookom
Microsoft Access MVP