Scatter Plot with 3 Parameters and Different Markers

[richardsilber]

I'm conducting analysis on physical (P) and virtual (V) server cpu and memory utilization.

1. I'd like to plot a scatter plot that shows cpu utilization on the x-axis, memory on the y-axis and shows either P or V at each data point.
2. Alternatively I'd like to show a different color/style for each data point marker depending if it's P or V.
3. I'd like to be able to choose whether to display P&V, P or just V servers.

I've uploaded a sample of the data.
Thanks in advance for any assistance.
Richard

 

[richardsilber]

I've uploaded a version of what I'm looking for that was produced using Tableau. I'd like to duplicate this using Excel.

 

[Luke M]

Quick mash-up, but here's the chart:

 

[richardsilber]

Quick mash-up, but here's the chart:

Thanks Luke. Exactly what I was looking for!