Creating a 4 quadrant chart which can help access testing quality

[renuka vasudevan]

Hi ,
I would like to do a testing release certificate and would like to show the data in a quadrant chart as follows

Module Defect density(defects/100 tcs) Test coverage
CASA 7.8 20
LOANS 2.3 86
DEPOSITS 4.5 100

I would want test coverage on x axis and the defect density on the y axis. Typically the 4 quadrants would be

High defect density, high test coverage
High defect density, low test coverage
Low defect density, high test coverage
Low defect density, high test coverage

So my above data should fall in one of the quadrants.

Please help me create this chart. Also each of the value should be plotted along with the labels (module, defect density and test coverage)

 

[Faseeh]

What is the criteria for High/Low Defect Density and High/Low Test Coverage?

 

[renuka vasudevan]

Hi Faseeh ,
Value less than 2.76 should fall in Low defect density
Value greater than 2.76 should fall in high defect density
Value less than 50 should fall in Low test coverage
Value greater than 50 should fall in High test coverage

 

[Faseeh]

You mean that each point for your data will have two components on representing density and other being test coverage. if that is true you can simply use a Scatter Chart for this. See attachment.

 

[renuka vasudevan]

Thank you sir , i think this solves my problem. One last help i would want , each of the quadrant , can we give it a colour. Also for each data point , i want the module name as the label. Please let me know how i can achieve this

 

[Khalid NGO]

Hi,
I think you can do this with the following steps:

One last help i would want , each of the quadrant , can we give it a colour.

Right click on data series > Format Data Series > Marker Fill > Vary Colors by Point.

Also for each data point , i want the module name as the label.

1) Right click on data series > Add Data Labels
2) Right click on Data Labels > Label Options > check / un-check Label Contains

Regards,

 

[Faseeh]

Hi All,

Please see if this helps. You can adjust the Y Axis Scale But if you change X axis the chart will be disturbed.