Pivot Chart VBA question

[joeshu26]

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!