View Single Post
  #1   Report Post  
Cawen
 
Posts: n/a
Default Find and replace data in an Excel chart object

Hi,

In a workbook it is possible to find and replace data in cells and formulas.
Is it possible in any way to find & replace data in series in a chart object?

In have charts with more than 100 series on each chart and I would like to
be able to change all series on a chart using an automated routine.

Thanks