Hello,

Thank you, jpr73! I appreciate the help. Actually, the Dashboard contains different graphs and different categories in one sheet making it difficult for the users to select per graph, and putting a lot of pivot tables isn't helpful with the file size of the Dashboard.

I'm not sure if there are other ways to work on having dynamic legends.

Rekussu