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