creating pie chart from other charts

[honnour]

Hello,

I have 4 charts that takes inputs from a table according to the fields on the table.
What I want to do is create a new chart that will summarize the other 4 charts.
For example;
Chart 1 has 2 "very good" answers, 1 "good" answer and 3 "very bad" answers
Chart 2 has 3 "very good" answers, 2 "good" answers and 4 "very bad" answers

New chart will come up with a solution like 5 "very good" answers, 3 "good" anwers and 7 "very bad" answers

How can I do that?

Thank you very much.

 

[apr pillai]

You can do one of two options:

1. Create a Total Query Summarizing required Values from the Table and use it as PIE Chart source, OR
2. Combine all four Chart Source Queries in a Union Query and create a Total Query summarizing values using the Union Query as source.

Check the following link for details on Union Query: Union Query