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)
Bookmarks