Hello Chandoo,
I am attempting to setup a scatter plot that takes metrics and translates them onto a the scatter plot (automatically). The purpose of this diagram is to map the quality of our team’s relationships to other focal points. Below is a description of what I am trying to accomplish:
Each of our team members own their own scatter plot. So, for example, my scatter plot should show all of the relationships that I have (via dots to represent the different relationships).
The plot is divided into 4 square sections - 2 on top (or above the x axis) and 2 below (or below the x axis). These different sections represent different strategies for our team members’ relationships.
The scatter plot is also divided in three circular sections stemming from the origin (where the x and y axis intersect). These three circles encompass one another starting with the smallest in the center (like nesting/matryoshka/babushka dolls).
The smallest circle (closest to the origin) is meant to represent the closest relationships (or level 1 relationships).
The second circle fits around the level 1 circle and is meant to represent relationships that are not as close as the relationships in the center (or level 2 relationships).
The third circle (encompassing both the level 1 and level 2 relationships) is meant for level 3 relationships (the least close relationships).
Each of the plots on this scatter graph should represent a relationship. So, for example, if ‘Relationship 1’ is a level 1(very close) relationship and is within my strategy 2, the dot representing that relationship should end up in the most center circle and in quadrant 2. For example, if ‘Relationship 2’ is a level 3(least close) relationship and is within my strategy 4, the dot representing that relationship should end up in the least center circle (furthest from the origin) and in quadrant 4.
I want to be able to automate this so that our team members could go into an excel sheet, for each relationship, indicate the level of close-ness and what strategy that relationship should be aligned with, and this would cause the relationship point to be plotted on our scatter plot in it’s respective quadrant and circle (or closeness to the origin).
I am not very good with building diagrams in Excel and desperately need help in order to make this happen. Please let me know if you have any lessons that I might be able to use to help me to compose this tool. Any help would be greatly appreciated.
Thank you,
CoCo
I am attempting to setup a scatter plot that takes metrics and translates them onto a the scatter plot (automatically). The purpose of this diagram is to map the quality of our team’s relationships to other focal points. Below is a description of what I am trying to accomplish:
Each of our team members own their own scatter plot. So, for example, my scatter plot should show all of the relationships that I have (via dots to represent the different relationships).
The plot is divided into 4 square sections - 2 on top (or above the x axis) and 2 below (or below the x axis). These different sections represent different strategies for our team members’ relationships.
The scatter plot is also divided in three circular sections stemming from the origin (where the x and y axis intersect). These three circles encompass one another starting with the smallest in the center (like nesting/matryoshka/babushka dolls).
The smallest circle (closest to the origin) is meant to represent the closest relationships (or level 1 relationships).
The second circle fits around the level 1 circle and is meant to represent relationships that are not as close as the relationships in the center (or level 2 relationships).
The third circle (encompassing both the level 1 and level 2 relationships) is meant for level 3 relationships (the least close relationships).
Each of the plots on this scatter graph should represent a relationship. So, for example, if ‘Relationship 1’ is a level 1(very close) relationship and is within my strategy 2, the dot representing that relationship should end up in the most center circle and in quadrant 2. For example, if ‘Relationship 2’ is a level 3(least close) relationship and is within my strategy 4, the dot representing that relationship should end up in the least center circle (furthest from the origin) and in quadrant 4.
I want to be able to automate this so that our team members could go into an excel sheet, for each relationship, indicate the level of close-ness and what strategy that relationship should be aligned with, and this would cause the relationship point to be plotted on our scatter plot in it’s respective quadrant and circle (or closeness to the origin).
I am not very good with building diagrams in Excel and desperately need help in order to make this happen. Please let me know if you have any lessons that I might be able to use to help me to compose this tool. Any help would be greatly appreciated.
Thank you,
CoCo