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.
Bookmarks