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