I am trying to create a graph that would show revenue on the x axis and time spent on the Y axis and then the dots would grow in size based on revenue and I also want the color of the dot to change based on satisfaction level rating. Here is the some sample date
Customer Revenue time Hr satisfaction
Cust A 25000 10 5
Cust B 17500 5.5 3
Cust C 7000 8 2
Cust D 12000 9 4
The dot would be red if it was 1 or 2, Yellow if it was 3 and Green if it is 4 or 5.