Creating Charts with Many Data Series'

Hello,

I'm often creating charts with anywhere from 30 - 100 series' of data. I have been doing this by right clicking the chart and entering a new data series for each set of data. Is there any way to format my data so that I can select a large range and have it auto create a separate series for each set?

I've attached a sample document with 20 data series' that I would graph in a scatter plot. If you have a solution you will have saved my wrists from certain carpel tunnel!