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:

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)

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