Hi all.
I have 8 columns of xy coordinate data (player 1 x, player 1 y, player 2 x, player 2 y, player 3 x, players 3 y, player 4 x, player 4 y) and I am looking to create an interactive scatter chart. If I select player 1 from the drop down menu I would like the chart to display just their xy data..... And the same idea for all other players.
Does anyone know how I can achieve this in excel 2016?
Many thanks.
Marc
I have 8 columns of xy coordinate data (player 1 x, player 1 y, player 2 x, player 2 y, player 3 x, players 3 y, player 4 x, player 4 y) and I am looking to create an interactive scatter chart. If I select player 1 from the drop down menu I would like the chart to display just their xy data..... And the same idea for all other players.
Does anyone know how I can achieve this in excel 2016?
Many thanks.
Marc