Creating the bubble chart should be easy. It looks like you want to use column D for the X data, Column E for the Y data, and Column C for the z (bubble size) data. Having z to the left of x and y is probably the hardest part of this. My first suggestion might be to add a helper column in F =C2 copied down. Then you can use columns D through F as the source data for the bubble chart and Excel will easily and automatically be able to see which should be X, Y, and Z. (http://office.microsoft.com/en-us/ex...749.aspx?CTT=1)

The other thing to look at is the arbitrary axis technique described here: http://peltiertech.com/Excel/Charts/ArbitraryAxis.html to create and label the X and Y axes with your text labels.