So I have like 10 spreadsheets that are all set up the same way but with different data (basketball statistics for different players). I'm going to want 3 or 4 charts on every spreadsheet for each player. Now I don't want to have to manually create 30 different charts... Can I make a chart on the first spreadsheet and copy it over somehow so that it updates the data ranges for the same ranges but on spreadsheet 2?
Bookmarks