How to have consistent colors in a 2D Column Chart

Hi, I would appreciate if someone can kindly let me know if the following is possble and If so, how it can be done.

I want to have 3 charts in a Exelsius dashboard, all are 2D column charts. The tricky part is, one of the dimentions is Client, and I would want to have the same color the the same client across all charts. Eg:

The data will be:

Region Client Turnover

North A 100,000

B 200,000

West B 250,000

C 80,000

South A 125,000

C 250,000

I want to display Client A say in "red", Client B say in "green" consistently across all charts.

Really appreciate any advice.

Thanks

Shamith