Hi, I've got a bubble graph that I want the colours in each bubble to reflect the split between two values (like a pie graph) e.g. each bubble reflects a store and the two colours within the bubble change to show the ratio between summer and winter sales (60/40).

I can pretty much draw the graph, but the macro to adjust the percentage is proving a headache, can anyone help?

Thanks
Angus51