Primary Dimensions Labels

[#1]

Hi,

Is it possible to change the Primary Dimensions Labels angle/orientation of a (bar) chart with a VBScript macro?

Just as you would do in the property windows by selecting the "-", "/" or "|" modes!

Thanks, in advance, for your answers.

Lilian

[#2]

Hi,

See if the attached sample can help you.

Cheers.

[#3]

Thanks for the quick answer BlackRockS.

I did find something interesting in your exemple but actually I've noticed that I was incomplete in my post!

What I try to do by macro is to change the primary (or secondary) dimension label orientation like you can do in the property box, you know the "-", "/" or "|" modes!

Thanks again BlackRockS.

[#4]

Hi,

See if the attached sample can help you.

Cheers.

[#5 · Accepted solution]

Thanks a lot BlackRockS, that's what I wanted!

Cheers

-- Lilian

[#6]

lilian You must mark blackrocks answer right, not your reply

[#7]

Just in case people have personal edition and can't open the file... this is the macro from the above attachment.

sub tst()

set chart = ActiveDocument.Sheets("Main").CreateBarChart

chart.AddDimension "Clients"

chart.AddExpression "sum(ConsultingAmount)"

set p = chart.GetProperties

'p.ChartProperties.MajorDimensionTextMode = 0   'horizontal -

'p.ChartProperties.MajorDimensionTextMode = 1   'vertical |

p.ChartProperties.MajorDimensionTextMode = 2   'inclined /

chart.SetProperties p

end sub