[ARCHIVED THREAD] - Excel Wizzards

Posted: 8/23/2009 12:15:47 PM EDT

I'm trying to make a scatter plot on two sets of data. How can I show both sets of points as different colors?

Posted: 8/23/2009 12:34:33 PM EDT

[#1]

anyone?

Posted: 8/23/2009 12:38:34 PM EDT

[#2]

In the graph, pick a point from the set you want to change: Right click > Format data series.

Posted: 8/23/2009 1:15:44 PM EDT

[#3]

I tried that, it changes all of them. I want male one color and female another.

Posted: 8/23/2009 1:20:22 PM EDT

[#4]

Never mind, my wife figured it out.