Hi, I have some data which i need to present in the shown in image below.
Schema and Data:
CREATE TABLE ScatterTest(ID SMALLINT IDENTITY(1,1),Effort SMALLINT, Benefit SMALLINT,Category VARCHAR(15) ) INSERT ScatterTest SELECT 1,3, 'Revenue' UNION SELECT 2,1,'Cost' UNION SELECT 3,3,'Revenue' UNION SELECT 1,2,'Cost' UNION SELECT 3,1,'Production' UNION SELECT 2,2,'Production' UNION SELECT 1,1,'Production' UNION SELECT 2,2,'Others'
Explanation: There are 8 projects in the table. I need to show these projects across Efforts and Benefits. 1="H"for High and 2 stands for "M" as in Medium. These projects are then categorised in various formats, so I also need to cluster them with different colour coding scheme. (As you can see in the image)
Now in the image below you might see wrong plotting of the projects. That's just for representational understanding.