Thread: Editing multiple charts on a worksheet

I'm trying to edit multiple charts on multiple worksheets. Each worksheet has the same charts that display data about the worksheet it is on. Each quarter the data is updated and so each quarter I need to update the charts so that the new data is on them. The problem is there are about 20 charts per worksheet and about 30 worksheets.

I've been clicking each chart and going to Select Data to update them manually and this takes a long time. What needs to be updated on each chart are 2-3 Series (Series value) entries and 1 Category (Axis label range) entry. For example:

Axis
=Company!$C$2:$H$2
needs to be
=Company!$C$2:$I$2

Series
=Company!$C$95:$H$95
needs to be
=Company!$C$95:$I$95

Just one letter on each needs to be changed. Is there any way to do this for all the charts on each worksheet beside manually clicking each chart?

Any help would be greatly appreciated.

If this is something you're going to be adding to for an extended period of time, there's dynamic lists, that will extend to the length of a series of numbers as soon as one more is added to the bottom of it.

Sound about right?