Charts
 

Hello,

I have 70 charts in my Excel workbook and I need to update their source
data ranges on a regular basis. I was hoping I could somehow traverse
all the charts, retrieve their current source data ranges and update
those ranges (I'm adding an additional column every time). Is there a
way to 1)Traverse all the charts in VBA and 2)Retrieve a chart's
current source data?

Thanks in advance!