Dynamic Bubble Chart - Legend & Data Labelling problem

[Jaspal]

Hello all,

In my Dynamic Bubble chart, I have used offset formula in Named ranges for relevant criteria, but my Legends don't pick up individual products, I have switch legend on, its just dumped as one. Same problems with data labels. I need to pick up Product names for each Bubble without having to individual pick it up.

Would appreciate a Macro and a formula based solution. I have copied the spreadsheet below, could not find a button to upload the spreadsheet.

OFFSET(Test1!$C$5,,1,COUNT(Test1!$D$5:$D$27))</SPAN>
Eg of my formula, used in my name range</SPAN>	Product</SPAN>	Revenue CAGR </SPAN>	Ave Contrib Margin</SPAN>	Revenue 2012B</SPAN>
	A</SPAN>	8%</SPAN>	74%</SPAN>	28,619.2 </SPAN>
	B</SPAN>	9%</SPAN>	65%</SPAN>	7,691.5 </SPAN>
	C</SPAN>	17%</SPAN>	61%</SPAN>	9,685.5 </SPAN>
	D</SPAN>	23%</SPAN>	52%</SPAN>	2,347.3 </SPAN>
	E</SPAN>	3%</SPAN>	41%</SPAN>	2,632.6 </SPAN>
	F</SPAN>	11%</SPAN>	70%</SPAN>	3,366.7 </SPAN>
	G</SPAN>	17%</SPAN>	57%</SPAN>	2,056.5 </SPAN>
	H</SPAN>	39%</SPAN>	17%</SPAN>	420.2 </SPAN>
	I</SPAN>	47%</SPAN>	54%</SPAN>	478.4 </SPAN>
	J</SPAN>	7%</SPAN>	43%</SPAN>	1,201.1 </SPAN>
	K</SPAN>	26%</SPAN>	37%</SPAN>	664.89 </SPAN>
	L</SPAN>	72%</SPAN>	32%</SPAN>	186.84 </SPAN>
	M</SPAN>	22%</SPAN>	68%</SPAN>	1,024.28 </SPAN>
	N</SPAN>	21%</SPAN>	27%</SPAN>	265.00 </SPAN>
Bitmap </SPAN> <TBODY> </TBODY>

<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL></COLGROUP>