Multiple charts over multiple sets of data over multiple worksheets.

I figured this would apply to programming - because excel doesnt offer this natively.

Multiple charts over multiple sets of data over multiple worksheets.

This may be a toughie

I have a workbook with about 20 work sheets, I am doing statistical analysis of baseball players.

each chart is roughly like this:

Please Login or Register  to view this content.

I want to create *separate* charts for each individual stat - the numbers are too far apart to put them on ONE graph the scales would be nuts (3B's range is 1-4 and AB's range goes into the 500's).. they'd all have the same X axis (the year) and scale the Y axis to the stat.

would there be an easy way to do this instead of manually creating each one?

(this would be for multiple players, so I'd be doing this process over and over)