Hi
Can someone please help me, I am trying to dynamically set the number format of an expression in a chart
Similar to:
| expItem.Label.v = ActiveDocument.fields(ViewMode&"PivotEx").GetPossibleValues.Item(0).Text expItem.NumAdjust = 2 'right align expItem.TextAdjust = 2 expItem.LabelAdjust = 2 'right align set expItem = p.Expressions.Item(i).Item(0).Data.ExpressionVisual.NumberPresentation ' Set the number format select case ActiveDocument.fields(ViewMode&"PivotType").GetPossibleValues.Item(0).Text case "Decimal" expItem.Dec = "." expItem.Fmt = "#,##0.00" expItem.nDec = 2 expItem.Thou = "," expItem.Type = 11 'fixed decimal expItem.UseThou = 1 case "Integer" expItem.Fmt = "#,##0" expItem.Thou = "," expItem.Type = 10 'integer expItem.UseThou = 1 |
|
|
I was wondering if how to find a list of values for expItem.Type, I coudn't find this info from the API guide.
I actually need to set the type to interval
Thanks
Andy