PDA

View Full Version : Scatter graph based on pivot table



codeghi
08-30-2019, 08:15 AM
Hi guys,
I'd like to create a scatter graph representing on the x and y-axis the values of a pivot table referred to specific resource names and a dates.
The table would change during the year by adding new resources and/or new x-y values referred to existing resurces but a different dates.
Plese look at the attached example file: the problem is I'm not able to insert any filter regarding the date and it's not possible obtain a dynamic graph that adapts to the table changings.
Any suggestion?
Regards
Codeghi