Edit multiple charts simultaneously
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.
"elle0612" wrote:
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
|