Help on configuring a Scatter Chart.

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.

March 18th, 2015 3:36am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics