Need VBA code to create dynamic line charts

[sabha]

Hi so this is my chart and x stands for a number (BTW my table has more than this many columns and rows):

Countries 1 2 3 4 5
AMS
Canada x x x x x
U.S. x x x x x
Mexico x x x x x

Europe
Italy x x x x x
France x x x x x
Germany x x x x x
Russia x x x x x

APP Korea x x x x x
China x x x x x
Japan x x x x x
Hong Kong x x x x x
India x x x x x

I want to create a dynamic line chart using VBA for every region. For example, when I highlight the range from Canada to Mexico, I want a line chart that will include all the country names in the legend and the numbers 1,2,3,4,5 will be by horizontal axis. Now when I highlight the range from Italy to Russia, I want to do the same thing but for those countries. Same goes for the countries under APP. The only thing common among all charts should be the horizontal axis of 1,2,3,4,5. Please help! Thanks

 

[Jon Peltier]

Dom -

Good adjustment of my code.

I don't understand why the OP is getting the messages he reports.

 

[sabha]

ughh I am so frustrated!! I don't know why this is happening! I can't even attach a picture of my workbook on here...

 

[sabha]

JKKK IT WORKS!!! I never noticed there was another code above this code since I never scrolled up...THANK Y'ALL SO MUCH!!