Getting datapoint X, Y and Size value from bubble chart

[kmurshed]

Hello,

I'm working on a bubble chart, and I wan't to create a macro that looks up the X, Y, and size values of each data point, and returns the corresponding text for the label. All that is based on a spreadsheet that relates the values and their intended labels.

My problem is how do I get vba to read the X, Y and size values of each datapoint.

Any ideas?

Thanks in advance

 

[pgc01]

Hello,

I'm working on a bubble chart, and I wan't to create a macro that looks up the X, Y, and size values of each data point, and returns the corresponding text for the label. All that is based on a spreadsheet that relates the values and their intended labels.

My problem is how do I get vba to read the X, Y and size values of each datapoint.

Any ideas?

Thanks in advance

Hi

Check the help for the series object properties.

3 properties will give you what you want

XValues, gives the X values of the points
Values, gives the Y values of the points
BubbleSizes, gives the sizes of the bubbles for the points

 

[kmurshed]

Thanks for the help, actually I used the label property itself in order to extract the x, y and bubble size values.. I did not manage to use the parameters you suggested for each point, only for each series, and I believe that would not solve my problem.
But maybe I chose the more complex solution..

Regards,
kmurshed