How do I overlay scatter charts?

[horse1]

I'm using Excel2010 to graph past performance data for horse races. For each race there may be up to 20 entrants. For each entrant there may be up to 10 past races listed, each of which I use to generate an x-y point representing distance in yrds and speed in yrds/sec. All graphs have identical scaling but it's hard to hold 10 or 15 graphs up to the light to pick the winner of the next race. All help appreciated. Thanks

 

[AlphaFrog]

You probably want to make a Pivot Chart where you can interactively select which horses to chart. Do a web search for Excel Pivot Chart Tutorial and you'll find several good step-by-step guides.