PivotChart Help???

[jsaliers]

I think that what I want is a Pivot Chart, but I am not sure. I have a query that supplies the data that I want, but I am not sure how to make an Access Report or Form that graphs the proper data. This is what I am looking for:

y-axis measures hours
x-axis consists of a program number
each program number broken into n project numbers
each project number broken into n disciplines

Here is a rough sketch...


7
6
5
4
3
2
1
Tech Eng CAD Tech CAD Eng CAD Maint
10 25 32
Program E137

Sorry, it is kinda cryptic. I need a way to graph the data produced by my query. I would normally export to Excel and brute force it, but it is for my boss, and he is not big on extra steps. Thanks in advance for any help!

Jon Saliers

 

[LittleSmudge]

Beware - multi thread timewaster alert.

thread703-528740


Thwack !




G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

 

[jsaliers]

The reason I put it in both forums is because I do not know which it applies to. I am not trying to waste anybody's time, as I know how prescious it is.

Jon

 

[LittleSmudge]

Then post a LINK




Of course - many people have concerns over which is the most appropriate board. So pick ONE and post it there and on other boards that seem suitable post a link to the original question.

That way you get all your responses in one place and other people get to see all the related comments as well.




G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.