Hello,

I'm trying to figure out how to apply labels to an Excel 2010 bubble chart via a MACRO instead of an add-in. Reason being is that I'm working remotely today and I don't have IT administrator privileges to download anything, much less a helpful add-in (such as XY Labeler).

It's a four-column matrix with the following headers:

A: Project
B: Spend (varies)
C: Impact (1-5)
D: Complexity (1-5)

I'm trying to rank the project by two variables -- C/Impact on the y-axis and D/Complexity on the x-axis. The size of the bubbles will be B/Spend. I want the project names to appear as labels on the chart. There might be upward of 50 or more bubbles, so doing it manually will be a pain.

Any help you can provide would be much appreciated.

Thanks,
Noah