Pie Chart

[rvanclea]

I want to create a pie chart in each detail section of a report that contains
fields from the single record in the detail section. I can get a bar chart of
this data, but not a pie chart (I just get one field that is 100% of the
pie). Is there a SQL statement or something I am missing here???

 

[Duane Hookom]

A detail section contains a single record so a pie chart might contain a
single value. You might only need to remove the Link Master Child properties
but I can't tell from where I am sitting.

Can you share info about your report's record source and the chart's Row
Source?

 

[rvanclea]

Sure, thanks for you help...

The record source is a query that includes fields from a single table. These
fields include id (primary key), emp_share and comp_share (currency). These
are the employees and company contributions to a retirement fund, and I wish
to print a report for each employee in the query that includes a pie chart
with these two contribution amounts. (I may expand this in the future, but
for now I am just trying to get these two fields to work)

The SQL statement I am trying:
SELECT Query1.comp_share, Query1.emp_share FROM Query1;

I am linking master and child by id - I removed those links and Access now
treats the emp_share and comp_share as parameters, prompting for a values and
using those for all the charts.

 

[rvanclea]

Actually, I goofed up before when I removed the linked fields - it does not
produce a parameter input but rather creates a pie chart with one field for
all employees, the same chart in each detail section.

What I want is: if employee #1 contributes $50.00, and the company
contributes $50.00 a pie chart to reflect those numbers in the detail section
for employee #1. Employee #2 might have $100.00 and $75.00 as their values,
and the pie chart in that detail section should reflect those values. Hope I
am making sense.

 

[Duane Hookom]

You may need to switch the chart display from horizontal records to vertical.
This is a property somewhere in the design view of the chart.

You could also try to normalize your data with a union query and so the
shares each create a record. The chart would the display results from two
records rather than one.

 

[rvanclea]

Thanks, Duane. I opened Microsoft Graph and under the data menu changed to
"Series in Rows", rather than "Series in Columns" and that did the trick.