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).…