I am using excel to collect data where variables are related to categories.. But it is up to the user to choose 2 to any number of categories.
I ahve already created a table which contains the categories selected and two related values (X and Y in a line chart).
CategoryA 6 5
CategoryB 10 4
Category E 11 9
Category F2 3 23
No way to know how much, and which category are used, but the table has extracted them
What I need is a way to create a scatter plot based on that automatically-generated table
and I don't want to do it manually (because, I plot numerous scatter plots for each user)
Thanks for any help