I have two data sources , And I created two different charts in different workbooks using these different data sources. I did color things by region in both of it. Finally I created a dashboard consisting of these two sheets. Now the problem is the color legend has became kind of global. when selecting any region in the color legend , it affects both the sheets, which ofcourse I don't want. Please help me ASAP. Attached is the workbook.
I downloaded the workbook and you can change the colour by right-clicking on one of the colour legends on the dashboard. Then choose Edit...Colours and choose a different palette for one of the regions.