Chart Properties Names

[nickedw0]

I am trying to set the Presentation to Horizontal in a macro. Is there a published list of property references?  After I use the GetProperties statement I do't know how to reference the Presentation > Horizontal property

[tamilarasu]

Hi Hanief,

set chart = ActiveDocument.GetSheetobject("CH01")

set p = chart.GetProperties

p.ChartProperties.Horizontal = true

chart.SetProperties p

[nickedw0]

Thanks Tamil. That's seems to be correct. I am not getting any errors, but the straight table is not flipping when I run this.

[tamilarasu · Accepted solution]

Ah got it.

set chart = ActiveDocument.GetSheetobject("CH01")

set cp = chart.GetProperties

cp.TableProperties.Horizontal = true          

chart.SetProperties cp

'chart.SetPixWidths_Horizontal true,200

'chart.SetPixWidths_Horizontal false,150

[nickedw0]

Thank you! The change from ChartProperties to TableProperties  works.

[tamilarasu]

Great. Have a super day!