Dear Excell Expert,
Im try to change my graph with gradient color using VBA. i do record VBA when changing color to gradient but i receive error notification as follows.
object doesn't support my property or method
i hereby send my VBA code .
Sub gradient()
'
' gradient Macro
'
'
ActiveSheet.ChartObjects("Chart 2").Activate
ActiveChart.FullSeriesCollection(1).Select
ActiveChart.FullSeriesCollection(1).Points(1).Select
Selection.Format.ShapeStyle = msoShapeStylePreset75
ActiveChart.FullSeriesCollection(1).Points(2).Select
Selection.Format.ShapeStyle = msoShapeStylePreset77
ActiveChart.FullSeriesCollection(1).Points(3).Select
Selection.Format.ShapeStyle = msoShapeStylePreset74
End Sub
Please need your advice.
Im try to change my graph with gradient color using VBA. i do record VBA when changing color to gradient but i receive error notification as follows.
object doesn't support my property or method
i hereby send my VBA code .
Sub gradient()
'
' gradient Macro
'
'
ActiveSheet.ChartObjects("Chart 2").Activate
ActiveChart.FullSeriesCollection(1).Select
ActiveChart.FullSeriesCollection(1).Points(1).Select
Selection.Format.ShapeStyle = msoShapeStylePreset75
ActiveChart.FullSeriesCollection(1).Points(2).Select
Selection.Format.ShapeStyle = msoShapeStylePreset77
ActiveChart.FullSeriesCollection(1).Points(3).Select
Selection.Format.ShapeStyle = msoShapeStylePreset74
End Sub
Please need your advice.