need some help: how color x,y scatter using a third variable

lazarus

New Member
Joined
Nov 15, 2005
Messages
1
I have a 2-variable scatter plot of about 50 points. about half of the pairs are female and half male. i know that you can use a third variable (column for sex) to color the data points on the chart, but i have forgotten how.

any help would be appreciated.

thanks
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Damon Ostrander

MrExcel MVP
Joined
Feb 17, 2002
Messages
4,239
Hi lazarus,

There are several different ways to do this. One way that doesn't require any code is to simply divide the male and female values into two different columns, which can be done using a formula in each column that lists just the values that are the desired gender. Then you can use two different series with different point colors to plot the results, and would look the same as if a single series with differently-colored points was used.

A second way is to use VBA code to color the points of a single series based on the gender. This is not difficult to do and I would be happy to email you a simple demo of this type of capability if you request it via email.

Damon
 

Watch MrExcel Video

Forum statistics

Threads
1,118,234
Messages
5,571,042
Members
412,358
Latest member
Eng Muhammed
Top