I have created graphs that show over 30 data series (for testing only). The
number of data series generally depends on your chart's Row Source property.
My sources are from 2 tables. One is Agency Errors and the other is Client
Errors. I want both of the errors to show on one pie chart as total errors. I
just don't know how to put them together.
You probably need a union query that combines both tables. If you can't
figure this out, come back with significant table and field names as well as
sample records.