Only showing selected legends on a chart

[Peter Davison]

Do you know if I can show only the first legend (left hand bars) in a chart like the chart below?
I want to do this because in the second bar the legend repeats for every instance of the first bar.
Thank you for your help

 

[BSALV]

i think i worked on this one before.
How many series was this ? +50 ?
Perhaps it's better to make a summary of all those series, so that there remain only 10 categories ?

 

[Peter Davison]

I believe you did and thank you for that.
I need all of the legends from the first set of series and just exclude all legends from the second series, because there can be so many.
Users can hover on the chart second series to show the legend
Is that easy?

 

[BSALV]

i can't remember me all details

 

[Peter Davison]

Do you know if it can be done by just a chart setting rather than a macro?