Conditional Coloring for Bubble Charts

Hello All,

This is my first post so I'm hoping some other bright minds can help me with this. I was hoping to create a bubble chart with the bubble color according to whether the criteria is buy or sell. Here is an example of the information:

Side PctADV Bps
Buy 0.0627 26.43
Sell 0.0407 25.93
Sell 0.1567 17.57
Buy 0.0852 96.49
Sell 0.0778 5.65

I would like the Y axis to be PctADV and the X axis to be Bps with the size of the bubble based on the Bps value. I was hoping to have buys be one color and sells be another. Is there any way to do?

Andy, thank you very much. This looks great. Saves me a lot of time.