Scatter Plot with color markers

  • Thread starter Thread starter JLewis
  • Start date Start date
J

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
 
Thank you very much! This is exactly what I needed. This works great! I
didn't know you could use conditional charts. Cool!
 
Back
Top