Data Labeling Macro Problems

[ryanbrenton]

I have a macro that I´ve been using to label series data points on a chart with a desired name rather than with the coordinate points. The macro works very well except for one thing, it is only meant to make one series. I would like to add a loop to it to make it be able to plot multiple series and label their data points. I´m not sure if this would work but ideally I would like to have the code distinguish a new series whenever there is a blank row in the data.
So for example:

AG32 4 5
BC78 3 6
HA23 2 0

AN32 4 6
JK12 2 6

I would like the code to creat two series one with AG32-HA23 with labeled data points and one with AN32-JK12 with labeled data points, and on the same graph.


The code I have looks like this:

Please Login or Register  to view this content.

I think I could add series with an outer loop to the format routine that looks something like

Please Login or Register  to view this content.

but I really don´t know the syntax of VBA at all and I´m honestly not a programmer. Could anyone show me how to do this and repost the edited code?

Thanks

[docMed]

I don't know the rules, but you're gonna get cracked down on for not wraping your code properly - just an fyi if you'd like to edit your post.

[ryanbrenton]

OK thanks what do I need to do wrap it correctly though?

[docMed]

edit your post, click go advanced, and theres a button that says wrap code, or something like that (its a #). Select your code, and click that button