Access Pie Chart

  • Thread starter Thread starter Sarah
  • Start date Start date
S

Sarah

I am making benefit summary reports for all our 500+ employees. I have set
up the report to pull all the data from a query. In the query I also have
the total employee cost and the total employer cost. I would like to create
a pie chart on each report with one color representing the employee cost and
a second color representing the employer cost. Each pie chart should be for
that employee only, not the entire staff. My report is grouped so that each
employee is on one page. I have tried to put the chart in the detail section
and also in the footer for the group - neither works. In fact, I can't get
the chart to show at all. Any help would be greatly appreciated.
 
You need to share more info about your chart control such as the Link
Master/Child and Row Source.

The chart should be in the employee group header or footer.
 
I'm not even sure I'm doing that much right, but here is what I've done. The
link master/child is CompleteName (the Primary Key) and the data I want
graphed is in ERTotal and EETotal. Everything is in one query.
 
Please provide information about the records in your report record source and
also the Row Source property of your chart. Without this, we can't help you.
 
Please provide information about the records in your report record sourceand
also the Row Source property of your chart. Without this, we can't help you.

--
Duane Hookom
Microsoft Access MVP






- Show quoted text -
Click to expand...

Good afternoon,

I am having the same trouble with an employee benefit program that I
am creating for our employees. I am hoping you can help me find what
I am doing wrong as well:

My report is running off a table that is attached to a query make
table with all the compiled information about the employee benefits,
eligibility, and cost. I am trying to show a pie chart breaking down
how much of their realized income falls into 4 catergories (1. Salary/
Overtime 2. 401(k) Match & 401(k) Profit Sharing 3. Medical
Benefits 4. Other benefits). The report looks perfect but the pie
chart comes up blank.

I have created a separate query for the pie chart data. The fields in
the query are [Employee] - employee name; [401(k) Match & 401(k)
Profit Sharing] - these figures are computed in the query make table(I
have taken them from the table "Benefit Statement Table"); [Medical
Premium] - figure also taken from the Benefit Statement Table; [Other
Benefits] - taken from the Benefit Statement Table; [Salary &
Overtime] - also from the Benefit Statement Table; and
[RealizedIncome] - also from the Benefit Statement Table.

The properties on the pie chart are:

Name Graph172
Size Mode Stretch
OLE Class Microsoft Graph Chart
Row Source Type Table/Query
Row Source SELECT Null,[Salary & Overtime] FROM
[graphing info];
Link Child Fields Employee
Link Master Fields Employee
Display Type Content
Update Options Automatic
Verb 0
OLE Type Embedded
OLE Type Allowed Either
Class MSGraph.Chart.8
Source Doc
Source Item
Column Count 0
Column Heads Yes
Visible Yes
Left 3.875"
Top 1.4167"
Width 2.4167"
Height 2.5833"
Back Style Normal
Back Color 16777215
Special Effect Flat
Border Style Solid
Border Color 0
Border Width Hairline
Tag

I really look forward to any response and information you can give
me. Thank you so much for your time. Have a great day!!!!!
 
What is returned in this query:
SELECT Null,[Salary & Overtime] FROM [graphing info];

I can't imagine this query is returning anything that would create a chart.

--
Duane Hookom
Microsoft Access MVP


[email protected] said:
Please provide information about the records in your report record source and
also the Row Source property of your chart. Without this, we can't help you.

--
Duane Hookom
Microsoft Access MVP










- Show quoted text -
Click to expand...

Good afternoon,

I am having the same trouble with an employee benefit program that I
am creating for our employees. I am hoping you can help me find what
I am doing wrong as well:

My report is running off a table that is attached to a query make
table with all the compiled information about the employee benefits,
eligibility, and cost. I am trying to show a pie chart breaking down
how much of their realized income falls into 4 catergories (1. Salary/
Overtime 2. 401(k) Match & 401(k) Profit Sharing 3. Medical
Benefits 4. Other benefits). The report looks perfect but the pie
chart comes up blank.

I have created a separate query for the pie chart data. The fields in
the query are [Employee] - employee name; [401(k) Match & 401(k)
Profit Sharing] - these figures are computed in the query make table(I
have taken them from the table "Benefit Statement Table"); [Medical
Premium] - figure also taken from the Benefit Statement Table; [Other
Benefits] - taken from the Benefit Statement Table; [Salary &
Overtime] - also from the Benefit Statement Table; and
[RealizedIncome] - also from the Benefit Statement Table.

The properties on the pie chart are:

Name Graph172
Size Mode Stretch
OLE Class Microsoft Graph Chart
Row Source Type Table/Query
Row Source SELECT Null,[Salary & Overtime] FROM
[graphing info];
Link Child Fields Employee
Link Master Fields Employee
Display Type Content
Update Options Automatic
Verb 0
OLE Type Embedded
OLE Type Allowed Either
Class MSGraph.Chart.8
Source Doc
Source Item
Column Count 0
Column Heads Yes
Visible Yes
Left 3.875"
Top 1.4167"
Width 2.4167"
Height 2.5833"
Back Style Normal
Back Color 16777215
Special Effect Flat
Border Style Solid
Border Color 0
Border Width Hairline
Tag

I really look forward to any response and information you can give
me. Thank you so much for your time. Have a great day!!!!!
Click to expand...
 
What is returned in this query:
  SELECT Null,[Salary & Overtime] FROM [graphing info];

I can't imagine this query is returning anything that would create a chart.

--
Duane Hookom
Microsoft Access MVP



Good afternoon,
Click to expand...
I am having the same trouble with an employee benefit program that I
am creating for our employees.  I am hoping you can help me find what
I am doing wrong as well:
Click to expand...
My report is running off a table that is attached to a query make
table with all the compiled information about the employee benefits,
eligibility, and cost.  I am trying to show a pie chart breaking down
how much of their realized income falls into 4 catergories (1.  Salary/
Overtime  2.  401(k) Match & 401(k) Profit Sharing  3.  Medical
Benefits  4.  Other benefits).  The report looks perfect but the pie
chart comes up blank.
Click to expand...
I have created a separate query for the pie chart data.  The fields in
the query are [Employee] - employee name; [401(k) Match & 401(k)
Profit Sharing] - these figures are computed in the query make table(I
have taken them from the table "Benefit Statement Table"); [Medical
Premium] - figure also taken from the Benefit Statement Table; [Other
Benefits] - taken from the Benefit Statement Table; [Salary &
Overtime] - also from the Benefit Statement Table; and
[RealizedIncome] - also from the Benefit Statement Table.
Click to expand...
The properties on the pie chart are:
Click to expand...
Name                         Graph172
Size Mode                  Stretch
OLE Class                  Microsoft Graph Chart
Row Source Type        Table/Query
Row Source                SELECT Null,[Salary & Overtime] FROM
[graphing info];
Link Child Fields          Employee
Link Master Fields       Employee
Display Type               Content
Update Options           Automatic
Verb                           0
OLE Type                   Embedded
OLE Type Allowed       Either
Class                         MSGraph.Chart.8
Source Doc
Source Item
Column Count             0
Column Heads            Yes
Visible                        Yes
Left                            3.875"
Top                            1.4167"
Width                         2.4167"
Height                        2.5833"
Back Style                 Normal
Back Color                 16777215
Special Effect             Flat
Border Style               Solid
Border Color               0
Border Width              Hairline
Tag
Click to expand...
I really look forward to any response and information you can give
me.  Thank you so much for your time.  Have a great day!!!!!- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

I have been getting an empty chart (no chart appears). I have gone
into the row source and played with it this afternoon, it now reads
"SELECT [graphing info].[Salary & Overtime], [graphing info].[Medical
Premium], [graphing info].[401(k) Match & 401(k) Profit Sharing],
[graphing info].[Other Benefits] FROM [graphing info];" and is
bringing back a pie chart for each employee. But the chart only
reveals the Medical Premium portion and says it is 100%. How can I
get more than one slice into the pie chart?
The other problem I have come up with (and I am not even sure how I
did this, was just playing with figures to see what changes what) is
that I can get the return of a report will the Medical benefits but
there is a slice for every employee of the company. It seems like the
chart is trying to total the premiums for all employes instead of
totalling the premiums for each employee.
Sorry if this makes no sense. I am really over my head with this and
hope I'm not making it worse by playing with the properties.
Again, thank you!
 
Duane,
I'm not sure exactly what information you need. My report Record Source is
"ReportQuery". The fields in this query include "ERPercent" and "EEPercent",
which together equal 100% for each employee. My pie chart has the following:
Row Source Type: Table/Query
Row Source: SELECT [ERPercent],[EEPercent] FROM [ReportQuery];
Link Child Fields: CompleteName
Link Master Fields: CompleteName
Display Type: Content
Update Options: Automatic
Verb: 0
OLE Type: Embedded
OLE Type Allowed: Either
Class: MSGraph.Chart.8
Source Doc:
Source Item:
Column Count: 0
Column Heads: Yes

Any help you could provide would be very, very appreciated.
Sarah
 
Back
Top