Hi,

I have created a bubble chart where I have set specific colours to each series.

However if I then sort the source table the formating doesn't follow and they all change.

Any way to fix the format so this doesn't happen and I keep consistent colours irrespective of sorting the source data ?

regards
Greg