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

--
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 here:

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/
>