Link Multiple Charts to Only One Combo Box

[robertgroen92]

Hi all,

I've used the following tutorial to create an interactive Excel Chart: http://chandoo.org/wp/2013/04/23/int...xcel-tutorial/

So if you click on a country in the combo box (in the sheet titled 'Dashboard'), a chart updates accordingly. However, I can't figure out how to link a second series of charts to the same combo box.
In the attached file you can see that I have data on Historic GDP and GDP Outlook for 8 countries. Currently, clicking on a country in the combo box updates the chart for GDP Outlook, and I would like it to also update the chart for Historic GDP.
I really hope someone could help me out with this, and any pointers in the right direction are appreciated. Thanks in advance!

Best,
Robert

Analysis Test.xlsm

[minnesotaart]

1. Create a second named range called "Dashboard2" with the following reference:
=CHOOSE(Dashboard!$J$1,Chart_GDPH_BE,Chart_GDPH_DK,Chart_GDPH_FR,Chart_GDPH_GE,Chart_GDPH_NL,Chart_GDPH_PL,Chart_GDPH_SE,Chart_GDPH_UK)
2. Just like you did for the "GDP Outlook" area, highlight the range of one of your charts but this time on the "1.Analysis" tab. Select it with CTL+C.
3. In the "Historic GDP" area, paste what you just copied as a Linked Picture (same as you did the first time for the GDP Outlook picture).
4. Now click on the picture and on the formula line type "=Dashboard2"
That should do it!

[robertgroen92]

Wow, that's actually an easy fix! I came up with another way that worked, but your solution is definitely more elegant. Thanks for your help!