multiple charts??

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:

nameLast     nameFirst    year    team    G    AB    R    H      2B    3B    HR    RBI
Kikowski     Rex         1998    MOB    128    299   53    84    28     1    17    67
Kikowski     Rex         1999    MOB    117    303   32    78    35     1    22    87
Kikowski     Rex         2000    TOU    150    506   83    127   38     1    12    99
Kikowski     Rex         2001    TOU    147    553   55    136   57     4    28    100
Kikowski     Rex         2002    TOU    163    591   98    155   34     2    34    109
Kikowski     Rex         2003    SB    131    499    76    166   47     4    42    125
Kikowski     Rex         2004    SB    155    597    87    175   44     1    57    125
Kikowski     Rex         2005    SB    150    505    96    158   56     1    35    138
Kikowski     Rex         2006    SB    157    573    99    143   47     1    24    108

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)

Create a chart for one player, copy that chart to the next player sheet. Change the sheetname in formula to match the player data.

In this example, change from Sheet1 to Sheet2
=SERIES(;Sheet1!$A$1:$A$3;Sheet1!$B$1:$B$3;1)

or

Create a chart that changes player data dynamically, depending on selection from a dropdown list.

Originally Posted by Steve R

Create a chart for one player, copy that chart to the next player sheet. Change the sheetname in formula to match the player data.

In this example, change from Sheet1 to Sheet2
=SERIES(;Sheet1!$A$1:$A$3;Sheet1!$B$1:$B$3;1)

or

Create a chart that changes player data dynamically, depending on selection from a dropdown list.

Yeah - series is not a valid function