One series for multiple graphs

[tylerhughesGPC]

Hello all,



I am new to access and I am creating a simple form based on a single query. The purpose of the database is to display KPI's for our employees. I have created the multiple graphs but I am being prompted every time, for each graph, as you can imagine this is less than ideal. I have searched high and low for an answer, to no avail.

So please, can anyone tell me how to use multiple graphs based on one series data?

THANK YOU!

[orange]

What exactly are you being asked for? What makes one graph different from another?
You could use some vba and set up a loop construct.
You must be adding some new value(s) for each graph.

[tylerhughesGPC]

Right now the focus is our Accounts receivables department. Our posters are being reviewed and scored on a variety of different factors( Worksheets, Lines, errors, call logs, per hour values of all, hours worked, etc) For example: I want to pull Suzy Q's KPI report. It will have a month by month graph of all of the above. So I will have a graph of worksheets completed in the month versus the prior months, a graph for lines, a graph for hours worked, and so on. Right now I am entering Suzy's name in the prompt box 10 times to populate all of the graphs. I need to type it in once and fill all of the graphs with just Suzy Q's information.

Granted- I may be going about it the wrong way but I am all ears to changes and progress.

[orange]

Since it seems a repetitive task, some form of looping jumps out.
Where exactly does the 10 come form?

In general the automation would be along the lines of:


get the name of the Employee for whom the graphs apply
For i = 1 to 10
Create/Print Graph (i) for Employee
'this may be some thing like OpenForm "monthlyReport" for SuzyQ set up as a where clause
Next i


This construct would loop 10 times, and would produce the graph for SuzyQ for month1, then month2....

You could extend this to select each employee based on some criteria and create the 10 graphs for each --all thru a loop set up.