If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pie Chart will only Display one slice - 100%
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 |
#2
|
|||
|
|||
Pie Chart will only Display one slice - 100%
First, make sure you don't have anything in the link master/child properties.
If the above doesn't 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 "Peter" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|