Why when I record a marco and change a chart (I have over a 100 and the migration from 2000 to 2007 loses the lines due to the formatting used) does the VBA no show what I am doing ? e.g.
In the example below I changed the fill colour and border style and colour of Data Point 3 yet the VBA only shows I selected Data Point 3.
In the following e.g I changed the Chart Type and the colour of all the charted Data
Help
Code:
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(1).Points(3).Select
ActiveSheet.ChartObjects("Chart 1").Activate
In the example below I changed the fill colour and border style and colour of Data Point 3 yet the VBA only shows I selected Data Point 3.
In the following e.g I changed the Chart Type and the colour of all the charted Data
Code:
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(1).ChartType = xlCylinderCol
ActiveChart.SeriesCollection(1).Select
ActiveSheet.ChartObjects("Chart 1").Activate
Help
