I am wondering if it is possible to create a userform that lets someone choose a person's name from a list and then what data they would like to plot. Then it creates a scatterplot chart with the person plotted and labled. In addition, the chart would also show the plot points for everyone else for the same data only they will not be labeled. The user can also open the userform again and make edits if they wish such as showing all data labels (or names of people). I have not started to build anything mainly due to not sure how to go about it.
And to clarify the data would be in a typical column set up where column 1 is the person's name and then the other columns would hold the other data options that the user could choose from in the userform. I would prefer to build this and run it in excel only.
Any ideas or direction would be greatly appreciated! Thank you.
Bookmarks