Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
At example below, teaches how modify number properties, but i did not found what show in percent.
Anyone can help me?
set chart = ActiveDocument.Sheets("Main").CreateStraightTablechart.AddDimension "ProductType"chart.AddExpression "sum(Amount)"set p = chart.GetPropertiesset np = p.Expressions.Item(0).Item(0).Data.ExpressionVisual.NumberPresentationnp.Dec = "."np.Fmt = "# ##0.00"np.nDec = 2np.Thou = " "np.Type = 11 'fixed decimalnp.UseThou = 1chart.SetProperties p
What I know it that you need to calculate the percent value and then use format as follows:
np.Fmt = "# ##0.00%"