Bubble colors in a scatter chart

[danialier]

Hello,

I have a Scatter Chart with a bunch of bubbles. Each bubble is a different country. On top I have a List Box where I select the quarters. When doing that the colors of the bubbles get changed. However what I really need is to have each country with an specific colour (i.e. US in blue, Germany in red, China in green,...) whatever quarter I select in the List Box.

Please help.

thks,dani

[alexandros17 · Accepted solution]

Try using persitent colours (is a checkbox in the tab colours)

[whiteline]

Hi.

Check Chart Properties->Colors->Persistent Colors.

[danialier]

Thanks !

[vikasmahajan]

You need to tick Persist Colors and repeat Last color option

Vikas

[rustyfishbones]

see below

[alexandros17]

Could you please mark the answer if it has been useful?

Thanks