Forms and Pivot Charts

[Guest]

I was wondering if it is possible to create a pivot chart from multiple
queries? I have three queries that are each associated with a different
part. The queries return the amount of each material used to create the
product. I would like to take these three queries and create a stacked bar
graph out of them. Each bar would be a part and each bar would be comprised
of the materials used to make the part. Any help i can receive would be
greatly appreciated. Thank you.

 

[Guest]

I figured out how to do it. I modified my previous queries to add a new
field to them. I then unioned all three queries together and created my
chart from there.