3 Replies Latest reply: Sep 11, 2014 8:57 AM by Graeme Smith RSS

    use Macro to change Number Format Setting


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


      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-|]