Hello there,
I'm hoping one of you can help me with the following problem I have with making xy scatter plots and their source 'table' data.
I have a workbook which contains results for each associated name and week (an example work book attached here: xy scatter for dynamic data.xlsx ).
-The names are dynamic and the weeks are dynamic.
I am working on having a single xy-scatter plot (and it's associated 'table') which will change as different names are selected from a data validation scroll down cell.
I am familiar with using dynamic named ranges but I can't wrap my head around how to formulate such a range when I need to pull data for names that are dynamic with weeks that are also dynamic and when all of this is in the same worksheet.
Do I need to use some combination of IF statments with dynamic named ranges? Or is this some type of conditional dynamic named range?
Any advice on how I can set up my xy-scatter plot to do this?
Thanks in advance,
Geoff.
Bookmarks