Macro to create a pivot chart for all tables created after using "Show report filter pages" functions

[GDH]

Morning all

The "Show report filter pages" is amazing to quickly create a new table for each individual item in the report filter but what I really need is the visual representation of this data. I have not come across a method of quickly creating a chart for all new tables produced.

Is there a bit of VB magic that could do this? I did try to record a macro which was highly unsuccessful.

Thanks in advance