How to create dynamic Scatter Plot/Matrix with labels and categories on both axis in Excel 2010?
- by user1581900
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?