Hi,
I have recorded the following macro to change a chart style. I would like to add some conditionality to the macro so that if the chart style equals ChartStyle = 27 then the macro changes the chart to ChartStyle = 26. And if the chart was already style 26 then it would change to chart style 27.
Sub Chartchange()
ActiveSheet.ChartObjects("Chart 13").Activate
ActiveChart.ClearToMatchStyle
ActiveChart.ChartStyle = 27
End Sub
Any help is appreciated, thanks!
I have recorded the following macro to change a chart style. I would like to add some conditionality to the macro so that if the chart style equals ChartStyle = 27 then the macro changes the chart to ChartStyle = 26. And if the chart was already style 26 then it would change to chart style 27.
Sub Chartchange()
ActiveSheet.ChartObjects("Chart 13").Activate
ActiveChart.ClearToMatchStyle
ActiveChart.ChartStyle = 27
End Sub
Any help is appreciated, thanks!