Scatter Plot with color markers

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
 
J

JLewis

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top