Thread: Clickable Bubble chart and drilldown

Hi guys,

Let's keep it simple, I have been looking everywhere on the internet but impossible to find a tutorial on how to do the following

I have a worksheet with one bubble chart and one bar chart.

The bubble chart shows 50 bubbles, each representing a country. X-value is the poverty rate, Y-value is the average income per capita and the size of the bubble is the population.

The bar chart is the evolution in time of the population from 2000 to 2010.

I would like to link both graphs, so that when I click on a bubble (a country) in my bubble chart, the bar chart shows the evolution of the population for this country. So basically what I need is a vba function that would return the name of the country when I click on a bubble. And the rest should work with a dynamic range and a vlookup... but how to return the name of the country by clicking on the bubble chart???

Thanks in advance for your help

Originally Posted by Richard Buttrey

Hi,

Does the file mentioned in Jon Peltier's solution help you? See..

http://peltiertech.com/Excel/Charts/ChartIndex.html

and scroll down to Chart Events.

It will help you identify the point and from there you can no doubt work out the country.

HTH

Thanks Richard,

It is definitely a perfect beginning. However, it seems that the file is not working properly: on the "data and charts" worksheet, only the second chart in the left part (the one with numbers in red) seems to work perfectly and gives the x-y coordinates. I work with Excel 2007, could it be the cause of this problem? Or did Jon Peltier only code for this chart and no for the other five?