Find Replace in Excel Charts

[agmorgan]

I want to be able to find and replace in the axis titles of charts.

I made a chart with the x axis title "Freq (GHz)"
I then copied and pasted the chart many times and just modified the source data.
Now I realise I need the x axis title to say "Frequency (GHz)"

Anyone want to help me out with a macro to find and replace freq with frequency?

I think its going to be something like this

'Loop through sheets
'Is it a chart?
'If so what is the axis title
'Replace it?
   ActiveChart.Axes(xlValue).AxisTitle.Select
    Selection.Characters.Text = "Frequency (GHz)"

I'm quite tired today and am having difficulty working it through.
2 cans of Red Bull and I'm still drooping!
Any help much appreciated.