Pie charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to add a pie chart to a report and have it change with each
record to reflect just that records information. I have tried to do this,
but cannot seem to get it to work. I can only get all information or just
one 'piece' of the pie. Any suggestions?
 
You can use the Link Master/Child properties like you would between a report
and subreport or form and subform.
 
Don't you also have to do a crosstab query?
I haven't actually gotten pie charts within one record to work very well yet.
It seems like it would be an obvious thing that one might want to do, but
Access seems to regard this as a non-option
 
I think crosstabs generally muck up a pie chart. Pie charts generally show
one column of values where line and bar charts show multiple "series" of
data points.
 
But this is precisely the problem. Pie charts show one COLUMN of values. So
if, for example, someone wanted to show in a pie chart the percentage of
total compensation to an employee which was salary, and what percentage was
health care benefits, and other benefits, all of those numbers are stored in
a ROW. They are part of one employee's compensation record. And yet, a pie
chart is a very logical way to show this data, if we think of it in terms of
communication values.

I gave up on this problem a year and a half or so ago, because other things
were of more pressing importance. So I haven't gotten it to work. But as
I've learned other things about Access during that time, it seems to me that
the only way to change that row to a column would be to do a select query to
choose the specific employee and the values you were working with and then do
a crosstab query to change the row to a column. Am I wrong? Is there a
better way to do this? When I've talked informally to people about pie
charts in Access, I get the answer "Oh. Pie charts. No I haven't gotten
them to work either."
 
Have you considered normalizing your compensation with a union query so that
it doesn't look like a spreadsheet?

SELECT EmpID, "HealthCare" as Benefit, [HC] as Amt
FROM tblEmpBens
UNION
SELECT EmpID, "Dental", [Dental]
FROM tblEmpBens
....etc... ;

You can the graph your normalized benefits union query.
 
Thank you, yes. That is very helpful. And not obvious from the textbooks at
my disposal. Now I have a direction to go in to get those letters with the
pie charts working (we settled for text).

Duane Hookom said:
Have you considered normalizing your compensation with a union query so that
it doesn't look like a spreadsheet?

SELECT EmpID, "HealthCare" as Benefit, [HC] as Amt
FROM tblEmpBens
UNION
SELECT EmpID, "Dental", [Dental]
FROM tblEmpBens
....etc... ;

You can the graph your normalized benefits union query.

--
Duane Hookom
MS Access MVP


r. howell said:
But this is precisely the problem. Pie charts show one COLUMN of values.
So
if, for example, someone wanted to show in a pie chart the percentage of
total compensation to an employee which was salary, and what percentage
was
health care benefits, and other benefits, all of those numbers are stored
in
a ROW. They are part of one employee's compensation record. And yet, a
pie
chart is a very logical way to show this data, if we think of it in terms
of
communication values.

I gave up on this problem a year and a half or so ago, because other
things
were of more pressing importance. So I haven't gotten it to work. But as
I've learned other things about Access during that time, it seems to me
that
the only way to change that row to a column would be to do a select query
to
choose the specific employee and the values you were working with and then
do
a crosstab query to change the row to a column. Am I wrong? Is there a
better way to do this? When I've talked informally to people about pie
charts in Access, I get the answer "Oh. Pie charts. No I haven't gotten
them to work either."
Click to expand...
Click to expand...
 
Back
Top