Record-Bound Pie Chart in an Access Report

D

Dana W

The charts row source is the query I built with the employee ID, Healt
Benefit %, Other Benefit % and the Salary %. It is grouped by th
employee ID, and the %'s are Sums. Should I change those to somethin
else? The Link Master/Child properties are the employee ID, which i
does change to match the employee ID on the report. And yes, it sho
all the employees in the data sheet view on separate pages.

Thanks for all your help!
 
D

Duane Hookom

Can you change the graph from rows to columns or something like that? I
expect this would work if your data was normalized like

EmpID1 Health 11%
EmpID1 Other 21%
EmpID1 Salary 66%
EmpID2...
 
Top