I have a two part question:
I am plotting a matrix as multiple graphs: column1 v column2, column1 v column3 etc
I have a worksheet set up so that some of the graphs can be completely equal to 0. I am plotting all the graphs on the one set of axes for comparison, and so the null graphs don't appear. However, I am having problems getting a legend. I only want to display a coloured legend (each plot is a different colour) for each graph that is non zero. How can I do this?
Second part, I have created a text box next to the graph that displays the names of the non zero graphs as strings. Can I make these strings the same colour as their respective graphs?