I know Chart layout can be changed using ActiveChart.ApplyLayout (9)
.
How can I get the layout number of a chart?
I got ChartStyle and ChartType using this:
With ActiveChart
Debug.Print .ChartStyle
Debug.Print .ChartType
End With
Hypothetically, I should get the chart layout number using something like this:
Debug.Print ActiveChart.Layout ' It should print 9 in this case
I tried the above code, but didn't work. Excel forums only mention how to apply the layout, but not how to get the layout number. Please help.