Conditional series... Conditional format

I have results from a two-sided 'game' with more than 5,000 records
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 between
the two sides in which one side or the other is the winner and the
opposing side is the loser. There is a column that indicates which
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 the
location of the winner in all contacts. Also, I can easily segregate
the results by side with a filter and choose one side or the other to
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 code
each engagement by the winner's side. This seems possible if I can
insert a conditional statement in the definition of two series' source
data. The condition would test the 'side' of the winner, and the plot
locations would come from the X-Y location column. Otherwise, I seem
stuck creating two sheets (one sheet for each side's winning contacts)
or inserting additional columns and shifting the results for each side
to their own X-Y columns.

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

This is possible? Totally confusing?

Thanks for your insights. John


---
Message posted from http://www.ExcelForum.com/

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 he

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

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

JohnWRS wrote:

I have results from a two-sided 'game' with more than 5,000 records
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 between
the two sides in which one side or the other is the winner and the
opposing side is the loser. There is a column that indicates which
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 the
location of the winner in all contacts. Also, I can easily segregate
the results by side with a filter and choose one side or the other to
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 code
each engagement by the winner's side. This seems possible if I can
insert a conditional statement in the definition of two series' source
data. The condition would test the 'side' of the winner, and the plot
locations would come from the X-Y location column. Otherwise, I seem
stuck creating two sheets (one sheet for each side's winning contacts)
or inserting additional columns and shifting the results for each side
to their own X-Y columns.

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

This is possible? Totally confusing?

Thanks for your insights. John


---
Message posted from http://www.ExcelForum.com/