Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit multiple charts simultaneously
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Excel Charts to PowerPoint | Charts and Charting in Excel | |||
display multiple charts in a workshheet | Charts and Charting in Excel | |||
Disappearing scales on bar charts with multiple series | Charts and Charting in Excel | |||
Multiple charts in ChartSpace; problems with double Categories | Charts and Charting in Excel | |||
Multiple charts | Charts and Charting in Excel |