Dynamic bubble chart & labels

[Ztv]

Hi guys

I'm trying to make a dynamic bubble chart - please see attached.
I'm using the offset formula and namemanager to generate the data for my chart. And it IS working right now - when you add data to column B, C and D, it shows up in the chart.

However, my main problem is that I don't know how to make the labels dynamic (labels = the A-column in the worksheet). I wan't the labels to be shown the legend to the right of the chart (where "Test" is right now).

It seems like I need do to some VBA to fix it - or what?

Hope that someone can help me.

[Andy Pope]

You can link data labels to cells using this free addin.
http://www.appspro.com/Utilities/ChartLabeler.htm

As your chart is dynamic you will need to make the links using a full set of data. Use dummy data to create chart with maximum data points. Then link data to cells.
Once the link is make you should be okay to delete dummy data and any new data added will retain the linkage.

[Ztv]

Thanks, Andy. But since the VBA code is working right now, and the work has to be done soon, I'll stick to the VBA solution for now.

Btw. I just checked out your website. I'll definitely return to it later on, seems like you have a lot of nice tips and tricks

EDIT
Wow, I thought this was another thread, sorry for the misunderstanding I may have caused! The VBA I'm talking about can be found here:

http://www.excelforum.com/excel-prog...ml#post3832973