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:
I think I could add series with an outer loop to the format routine that looks something like
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
Bookmarks