How to get Chart Layout number in Excel using VBA?

360 Views Asked by At

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.

0

There are 0 best solutions below