Creating a chart from a query

[blackawp]

I need some help creating a bar graph/column chart from a query. The query is designed to compute average work time, re-work time, and queue time. As it stands, I only have the query populated with two fields; Average Cell Touch Time, Average Cell Queue Time. There are other fields that will need to be added, but in the meantime, I am sticking with two to try to understand whats going on.

The wizard doesn't seem too helpful and searching this site didn't help much either. Can someone spell it out for me in plain english?

 

[SkipVought]

Hi, blackawp,

Welcome to Tek-Tips.

What trouble did you run into?

What did you try that did on work as expected?

Skip,
[sub]
[red][/red]
[/sub]

 

[blackawp]

What I have currently are two times; Touch time and Queue time, both 500 and 381 minutes (respectively). This is pulled from a query. I am trying to put this into a bar graph, so I used the wizard, tell it to pull from my "Average Time" query, then tell it where I want to put this data. Below is the link to the screenshot.

http://i89.photobucket.com/albums/k207/derickg123/screen_shot.gif

After that, I go through the wizard and click finish at the end. I click "Print View" (as this is a report) and I see the bar graph as follows (screenshot below):

http://i89.photobucket.com/albums/k207/derickg123/screen_shot2.gif

This isn't what I want. I have several other categories that need to be added, and so I need to break it down as follows:

Touch Time
Queue Time
Re-work Time

The y-axis needs to be "minutes" while the x-axis needs to contain the stages that each category is contained in:

Investigation Time
(will contain touch, re-work, and queue time)
Corrective action
(same as investigation)
Release
(same as investigation)

and so forth. There are essentially going to be three bars associated with each stage. How can I get access to do this from a query?

 

[dhookom]

Take a look at your chart control's Row Source. This should probably be a crosstab query. If you can't figure this out, come back with the SQL view of your Row Source.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[jconstan]

hey Duane,

i have created a cross-tab query after reading this thread. and the graph looks beautiful. except for one thing. the "value" crosstab shows up in my graph and gives the wrong data. i would prefer if it did not show up at all.

the crosstab im working with has 12 months worth of values (days worked) grouped by employee. i need a graph to show the number of days worked for each month by each employee. one graph per employee. i have tried a million different ways and there always seems to be one minor problem each time!

query looks like this..

jan feb mar ...
emp 1 1 2 3
emp 2 1 2 3

 

[dhookom]

You need a report that returns a single record for each employee. Then add the chart in the detail section and set the Link/Master child properties to the employee.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[jconstan]

good call. nailed it. thanks a bunch!