Bubble or Scatter chart

Hi,

I need to create a scatter graph or Bubble Chart where

Salary on X axis should show.
Experience on Y axis should show.
Performance ranking should also show for accordingly with different colors.

Files is attached for reference.

Thanks in advance

See attached.

Do you want a bubble chart as shown on Sheet1, or a split scatter plot as seen on Sheet2 ?

thanks i want sheet one chart .. but can we see peformance Ranking (1-5) in different colors also.. ??

Mixing the bubble-chart and error-forcing to get them in different Series then.

This was pretty finicky to set up, I had to do a lot of the series selection manually rather than just fixing details of the automatic setup.