Set font size of Row Axis Member label

[Michael Weiss]

Hello All,
I am trying to set the font size of the row axis label on
a OWC 10.0 Pivot control. I am having a hard time
actually finding the correct object model path to the
label object. So far I have tried
ptable.ActiveData.RowAxis.label as well as
pview.RowAxis.label... where pview is the ptable object's
active view.
Anyone have any ideas on what the correct syntax would be
to access the row object's label's font size property?
Also the same for a column object's label?
Thank you,
Michael

 

[Alvin Bruney [MVP]]

what you need is the font object. from the font object you can attach the
correct attributes

 

[Michael Weiss]

Thank you...so it would be something like:
ptable.ActiveData.RowAxis.font.size = 8? - or -
ptable.ActiveData.RowAxis.label.font.size = 8?

Not exactly sure how to get to the font object...
Thanks,
Michael

 

[Alvin Bruney [MVP]]

ya but you would have to look for a row object with a property that returns
a font object. i'm not sure that it exists. if it doesn't you will not be
able to customize the font

 

[Michael Weiss]

Thank you. I hate to appear dense here but I really do
not have a clue how to get to the font object since
everything I have tried has resulted in a 'no go' and I
can't find the font object referenced in the OWC Pivot
control's object model. Would you have an example? I
really need to shrink the label text somewhat.
Thank you,
Michael

 

[Alvin Bruney [MVP]]

You have a couple of options here. The pivotfield, pivotlabel and pivotview
objects all return a pivotfont object. From this object you can set the
following attributes: Bold, Color, Italic, Name, Size, Underline. You can
obtain the pivotview object from the view object or any number of pivot*
objects such as pivotdataaxis, pivotaxis, pivotdata etc. The help docs
should help you figure out what the rest.