Let us consider a following data set:
Name | Age | Hair Color ----------------------------- John | Young | Brown Sophie | Old | Blond Adam | Mature| Blond Mark | Teen | Dark Jeremy | Old | Grey Alex | Young | Brown etc...
Both Age and Hair Color, can take only defined values(Young/teen/mature/old and Blond/brown/Dark/Grey). Name is the only real variable here.
I want to create a Scatter Plot / Matrix that will look something like that:
I know that I schould use this tool to add labels to the scatter plot.
I also found this youtube video that explains how to display categories on Y-axis
Moreover I need the chart to be dynamic as explained in another youtube video.
How do I combine all these approaches to get a Scatter Plot with categories as values on both axis?