I need to use a chart multiple times on the same sheet. Each chart will have the same relative location of its five series. Is there a way to easily switch the series of the copied chart to different rows? Or within a chart do I have to make all series changes manually?

Thanks for any input.