Conditional series... Conditional format

[JohnWRS]

I have results from a two-sided 'game' with more than 5,000 record
collected in 32 distinct runs of the game. Each record includes an X
Y location of an event and reflects the results of a contact betwee
the two sides in which one side or the other is the winner and th
opposing side is the loser. There is a column that indicates whic
side was the winner in each contact (reflected in a single record/row)


With a scatter diagram using the X-Y columns as a series, I can see th
location of the winner in all contacts. Also, I can easily segregat
the results by side with a filter and choose one side or the other t
see its winners' locations in contacts in an X-Y, scatter plot.

I'd like to view all the contacts on a single chart, but color cod
each engagement by the winner's side. This seems possible if I ca
insert a conditional statement in the definition of two series' sourc
data. The condition would test the 'side' of the winner, and the plo
locations would come from the X-Y location column. Otherwise, I see
stuck creating two sheets (one sheet for each side's winning contacts
or inserting additional columns and shifting the results for each sid
to their own X-Y columns.

I'm hoping to find a way to define a series as 'IF column A=Side1, THE
seriesSide1 is x=columnB, y=columnC. Then I could color format eac
series.

This is possible? Totally confusing?

Thanks for your insights. Joh

 

[Jon Peltier]

John -

You can't have the series formula do this, but you could do it with
worksheet functions, and split the data into two separate columns, then
graph two series. he technique is described here:

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

- Jon