I have written a VBA code that does the following:
make a xyscatter with multitude of series.
Group series in a number of major groups
Each grouped number of series have their own color coding.

I would now like to add to my graph a shape/textbox which legends the colors i used for my major groups.

The chart looks as follows:

multichart excel.jpg

Leaves me to make my own legend.

Any hintS?
It's kind of urgent (i have a couple of hours to make it work)