Edit multiple charts simultaneously

[Guest]

Hello

I would like to edit some text on the y axis of several similar charts on
separate chart sheets, is it possible to select these charts and modify the
text simultaneously for all charts selected?

Thanks

 

[Guest]

I can help you speed the process up a little...

Copy the following macro into a VBA module on the worksheet:


Sub Change_y_axis_label()
'
' Change_y_axis_label Macro
' Macro recorded 8/31/2006 by ChristopherTri
'
'
ActiveChart.Axes(xlValue).AxisTitle.Select
Selection.Characters.Text = "New Label"
End Sub


Insert the new y-axis label in place of New Label on the last line.

Select each chart, one at a time, and run the macro.