Hi,
I have created a bubble chart where I have set specific colours to each
series.
However if I then sort the source table (this not a pivot table just a
list) 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
--
Fullam
------------------------------------------------------------------------
Fullam's Profile:
http://www.excelforum.com/member.php...o&userid=33363
View this thread:
http://www.excelforum.com/showthread...hreadid=538528