Copy Excel Graphs into new worksheet without graph linking to original worksheet data

Screenshot attached

Originally Posted by Andy Pope

Find and Replace will not work on the charts Series formula.

You would need code to alter the series formula directly, so something like

activechart.SeriesCollection(1).formula=replace(activechart.SeriesCollection(1).formula,"$B$","$C$")

Hi there,

this is exactly what I need to know. I have generated quite a complicated - at least big - spreadsheet and realised in the end that I couldn't blot my data (problems with blotting time [hh]). So I have copy pasted the graphs from tab "analysis a" to all other analysis-tabs. Unfortunately, all refer to analysis a and replacement using ctrl+H doesn't work.

Does anybody know the solution? I do not know where I should use the code.

Many thanks!