Scatter Plot with color markers

[JLewis]

I was wondering whether it was possible to use a scatter plot where the
markers (plots) were different colors based on another criteria. For
instance, I have total sales (x) and price level (y) for the data but I was
wondering if I could have a different colored marker to correspond to the
customer category. So one column is the total sales, the next is price level,
and the next is customer category. I could put retail sales in green and
wholesale sales in red on the graph. I can't seem to get excel to do this. Is
this possible? I hope I explained it well. Thank you very much. - Jennifer

 

[Jon Peltier]

Set up a conditional chart:

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

- Jon

 

[JLewis]

Thank you very much! This is exactly what I needed. This works great! I
didn't know you could use conditional charts. Cool!