Pie charts : the colour assigned (from that palette) is controlled by the 'order' your metric comes out in the pie chart If you want consistant colouring then you need to ensure that your metics all come out in the same order (every time) - i.e. even with the metic (count) is zero you must still return in in the SQL (even though it does not get displayed in the pie.
Same goes for column / bar charts - you need consistant ordering of your metics (and providing zero values) to get consistant colouring (which is again defined in that palette).
Bubble charts are a bit different, you can define a display mapping for a bubble colour; see
THIS GREAT THREAD for a whole load of detail on bubble charts.