Dear Excel help,

I have managed to create a scatter graph based on a pivot table using dynamic ranges. I have found a macro to show the series name on the chart but this does not work for me as some of the plots are similar and as a result the series names are unreadable as they are on top of each other. Currently my legend shows the quantities, is there any way I can show the series name as the legend? I have changed the colours of the markers, just need to identify them via the series.

Many thanks in advance for your help.