copy same exact chart format but change rows

Hi ammartino - Yes, You have to go by selecting each range every time if you wish to have single line graph for diff dep or row. I don't think that you can do with find replace (again this will be manual so will recommend you should prefer to go with option to click on each line series and change the range / formula or create new graph (if you wish to) for new line).

Please let me know if my understanding is correct and my response helped you .