Macro to add Series on Graph

[valenmartinez35]

I am trying to automatically add series using VBA. I have a list of values that I want to graph and I want to see if I can automatically do it based on different values. My graph would be column K as the x-axis; column J as the y-axis and column B as my series names and pulling data from them. As right now I have been doing this manually, but I am sure theres a faster way to do it using macros.

[TABLE="width: 500"]
<tbody>[TR]
[TD]B-Column[/TD]
[TD]J-Column[/TD]
[TD]K-Column[/TD]
[/TR]
[TR]
[TD]405[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]405
[/TD]
[TD]11[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]406[/TD]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]385[/TD]
[TD]3.5[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]385[/TD]
[TD]3.4[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]566[/TD]
[TD]0.92[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]566[/TD]
[TD]8.6[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]