8 Replies Latest reply: Oct 30, 2012 3:01 PM by whiteline _ RSS

    dynamically change number formats on graph

      Hi,

       

      I'm trying to dynamiclly change the number format on a graph. Some of my lines of data are % and others are just numbers, so when the user filters I want the graph to change to what they have filterd on. I've got everything working except the number formats.

       

      I was able to do this fine on a pivot but unfortuantly the same logic does not seem to work on the graph. Heres what I used for the pivot:

       

       

      =

      IF(NumberFormat='%',NUM(SUM( {$<Type={'MonthTarget'}>} Data),'0.00%'),IF(NumberFormat='0.00',NUM(SUM( {$<Type={'MonthTarget'}>} Data),'0.00'),SUM( {$<Type={'MonthTarget'}>} Data

      )))

       

      Any help would be greatly appreciated.

       

      Cheers

       

      Simon