413
Using the Watch Window to Learn Rotation Settings
Using the Watch Window to Learn Rotation Settings
There is one icon on the Layout ribbon that is not recorded by the macro recorder. If you change the rotation of a 3-D
chart, the macro recorder records nothing.To see an example of this,you can follow these steps:
1. Turn on the macro recorder.
2. Select a surface chart.
3. Change the rotation settings.
4. Stop the macro recorder.
5. Switch back to Excel and change the formatting of the columns in the first series.Excel records this macro, which is
of little use:
Sub RotateChartRecordedMacro()
‘
‘ RotateChartRecordedMacro Macro
‘
‘
ActiveSheet.ChartObjects(“Chart ...