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

Set up a conditional chart:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"JLewis" wrote in message
...
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!

"Jon Peltier" wrote:

Set up a conditional chart:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"JLewis" wrote in message
...
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