use Macro to change Number Format Setting

[#1]

Dears,

I have a chart with Expressions that need show different data format depends on selection:

eg:

if '%' is selected, the number format in chart should show %. (In properties, there is tab called Number Format Setting, the 'Show %' should be tick in that case).

But if 'Actual Number' is selected, % would be disappear in chart (the 'Show %' box shouldn't be unticked).

Does anyone know how to use macro to control it?

Thanks a lot [8-|]

[Anonymous]

There is no need for macro. A "normal" way is to create two expressions, one for % and another for actual number, and group them in cycle. Define format for each in "number" tab.
One expression with different formats is possible as well, and also without macro. Define data format conditionally directly in expression, for example:
num(<your expression>, if(Var='%', '#,##0.00%', '###,###'))
And, use "Expression default" on number tab.

[#3]

In case anyone does need to do this via a macro for other reasons, try this thread:

Dynamic Chart Macro and Number Format Problem

[#4]

And this one:

Dynamic Chart - Expression, Number Format Problem