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.
JKarchner - 16 Aug 2006 18:26 GMT
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.
> 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
[quoted text clipped - 3 lines]
> of the materials used to make the part. Any help i can receive would be
> greatly appreciated. Thank you.