Dynamic Scatter Graph from DataTable from Pivotable (2013) PowerQuery not an Option

Good day,

I need help please, I need to create Dynamic Scatter graphs for 100 user using the excel template.

Initially thought I could create the scatter from pivot table (olap)
Scatter doesn't like pivot table (PowerQuery not at option), my data is dynamic so I read insert data into data table and as table increase or decrease the scatter will change.

i want the data table to read from pivot table, every time pivot table changes the data table changes

Any ideas?

Regards

Thank You for the link, however my issue is working on a workaround for Scatter Graph limitations reading from pivottable
a workaround i found was using powerquery or inserting text data into datatable for the scatter graph

now instead of textdata to datatable, is there a way to dynamically have the datatable refreshed dynamically fom privottable which then updates the scatter graphs

i want to add slicers on pivotable (which is olap cube)which controls the Scatter graph
i read using offset to gather rangers etc but i am clueless

Please help