XL2010 Heat Map Conditional Formatting within a Column Chart

[supermaths]

Hi
"First time caller, long time listener"

I've searched for a thread like this - indeed I found one so I added to the end of it, but got no replies - so here goes:

I have the following data:

<TABLE style="WIDTH: 96pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=128><COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17 width=64>Company</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; WIDTH: 48pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 width=64>Accuracy</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17>A</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70>0.488684</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17>B</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70>0.486047</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17>C</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70>0.466995</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17>D</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70>0.456205</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17>E</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70>0.436414</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17>G</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70>0.411593</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17>H</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70>0.408408</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17>I</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70>0.382772</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17>J</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70>0.379445</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17>K</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70>0.373541</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17>L</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70>0.373541</TD></TR></TBODY></TABLE><TABLE style="WIDTH: 96pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=128><COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68 height=17 width=64>Company</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68 width=64>Accuracy</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68 height=17>A</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68>0.488684</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68 height=17>B</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68>0.486047</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68 height=17>C</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68>0.466995</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68 height=17>D</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68>0.456205</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68 height=17>E</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68>0.436414</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68 height=17>G</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68>0.411593</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68 height=17>H</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68>0.408408</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68 height=17>I</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68>0.382772</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68 height=17>J</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68>0.379445</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68 height=17>K</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68>0.373541</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68 height=17>L</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl68>0.372145</TD></TR></TBODY></TABLE>
Which gives a very nice column chart.

But now I've been asked if I can show (on a conditional scale from green through to red) how these accuracy figures relate to the volume of visits each company receives.

The dataset now looks like this:

<TABLE style="WIDTH: 144pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=192><COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17 width=64>Company</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; WIDTH: 48pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 width=64>Accuracy</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; WIDTH: 48pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" width=64>Sales</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17>A</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70>0.488684</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" align=right>5000</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17>B</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70>0.486047</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" align=right>8200</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17>C</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70>0.466995</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" align=right>7000</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17>D</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70>0.456205</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" align=right>6480</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17>E</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70>0.436414</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" align=right>7500</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17>G</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70>0.411593</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" align=right>4949</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17>H</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70>0.408408</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" align=right>544</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17>I</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70>0.382772</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" align=right>22000</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17>J</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70>0.379445</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" align=right>1500</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17>K</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70>0.373541</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" align=right>960</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; HEIGHT: 12.75pt; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70 height=17>L</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" class=xl70>0.372145</TD><TD style="BORDER-BOTTOM-COLOR: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #e0dfe3; BORDER-RIGHT-COLOR: #e0dfe3; BORDER-LEFT-COLOR: #e0dfe3" align=right>3960</TD></TR></TBODY></TABLE><TABLE style="WIDTH: 144pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=192><COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70 height=17 width=64>Company</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70 width=64>Accuracy</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" width=64>Visits</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70 height=17>A</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70>0.488684</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" align=right>5182</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70 height=17>B</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70>0.486047</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" align=right>8517</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70 height=17>C</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70>0.466995</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" align=right>7301</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70 height=17>D</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70>0.456205</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" align=right>5922</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70 height=17>E</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70>0.436414</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" align=right>7560</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70 height=17>G</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70>0.411593</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" align=right>4949</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70 height=17>H</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70>0.408408</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" align=right>544</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70 height=17>I</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70>0.382772</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" align=right>25697</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70 height=17>J</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70>0.379445</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" align=right>1259</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70 height=17>K</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70>0.373541</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" align=right>960</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70 height=17>L</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" class=xl70>0.372145</TD><TD style="BORDER-BOTTOM: #e0dfe3; BORDER-LEFT: #e0dfe3; BACKGROUND-COLOR: transparent; BORDER-TOP: #e0dfe3; BORDER-RIGHT: #e0dfe3" align=right>3145</TD></TR></TBODY></TABLE>

So, what I'm after is the column chart showing the accuracy numbers, but colour coded (like XL does within it's conditional formats in cells) on the visit volumes.

Can anyone help please?

 

[Andrew Poulsom]

Maybe this will help you:

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

 

[supermaths]

Hi Andrew

Thanks for your quick response!

I have seen this before - but it doesn't quite fulfil my needs - I was hoping for something a little more dynamic than having to apply a colour manually to each column.

The visits total can (obviously) change and therefore the colour applied to each column would also change - as i'd like it to be a conditional indicator in relation to the other companies.

 

[Andrew Poulsom]

If it were possible to make it more dynamic, I'm sure that Jon Peltier would have done so.

 

[supermaths]

Cheers!

(Strikes me he needs to pull his finger out!!!)

 

[Jon Peltier]

Don't know how to interpret that last comment, so I'll ignore it.

The conditional formatting approach Andrew cited is only as dynamic as your formulas. If the formulas link properly and calculation is set to automatic, the colors should update when the numbers are changed.

One approach to show this information more effectively than with color (which is a poor feature to use for encoding qualitative values) is to add the Sales or Visits data as another series to the chart, and perhaps change it to a line and plot it on the secondary axis. It's not a perfect approach, however, since it isn't a good way to show correlation.

A better way to show correlation between the variables is to create an XY Scatter Chart, using one variable as X and the other as Y. You can label the points using Rob Bovey's Chart Labeler (free from http://appspro.com). You'll have to decide which variables to assign to X and Y, and how to deal with the outlier from Company I.

 

[supermaths]

Thanks!

Great suggestions!

I'd completely ignored the idea of scattering.

Many thanks!