Capture Pivot Chart data?

[Paul]

Hello,

I have a pivot chart based on a union query. Users can filter the pivot
table by date.
I would like to show a summary of the pivot chart showing Grand Total, Total
for each category, etc. but am not sure the best way to go about it.
Thought maybe I could capture the data from the chart and stick it in a
table or something.
Any info or suggestions would be appreciated.

Thanks