Oct 12 2023 11:58 AM
Is it possible to have a radar graph update based on a variable selected in a specified cell? I have a table of date using names in a column. The row has numerical scores related to the name in the column. Is it possible to have a radar graph generated based on a cell selecting from the Name column?
Criteria 1 | Criteria 2 | Criteria 3 | Criteria 4 | Criteria 5 | Criteria 6 | Criteria 7 | Criteria 8 | Criteria 9 | Criteria 10 | Criteria 11 | |
Sam | 2 | 9 | 4 | 6 | 8 | 7 | 5 | 2 | 6 | 8 | 5 |
John | 6 | 9 | 5 | 3 | 2 | 1 | 4 | 8 | 2 | 3 | 6 |
Kim | 8 | 9 | 6 | 3 | 5 | 7 | 8 | 5 | 6 | 4 | 7 |
Jud | 5 | 9 | 7 | 6 | 3 | 2 | 4 | 5 | 7 | 5 | 2 |
Oct 12 2023 01:02 PM
Are you looking for the Radar Chart to only plot data for people selected in Criteria 1? If so, you could add a filter to the data and filter by name. A fancier option is to table the data and add a slicer to change the names displayed.