How to syn colors between a Marimekko and Cluster Bubble with SAC?

[Former Member]

I am building a basic SAC Story where I have a Marimekko and a Cluster Bubble.

I however, cannot make these two graphs use a "synchronized color palette" for the common Dimension they share!

My first problem is to understand which is the underlying rule that sets the Cluster Bubble color-category (the legend), as the graph does not support the color-assign functionality...

Anyone has faced this before; is there any alternative way to make this work? Thanks for any feedback.

[roy_jin]

There's a color sync setting on chart to synchronize color across different charts.

But it's strange that the cluster bubble chart doesn't have such setting.

What you can do is to edit your marimekko chart and use assign colors to manually assign the color for each dimension member according to your cluster bubble.

[Former Member]

Thanks for the comment, I appreciate it.

Unfortunately, the Assign function from Tools/Conditional Formatting does not help either to keep colors "attached" to the content of a given dimension (lost-> red, cancel-> orange, won-> green) at the bubble plot; for example when filtering the data by another dimension, the bubble plot colors are still switching around...

The only way I see to keep two charts syn is thru the Color Syn functionally, but it is surprisingly only available at certain charts, quite a strange limitation!