0 Replies Latest reply: Nov 18, 2014 5:20 AM by Saukarsha Roy RSS

    Custom color in Linear Gauge


      Hi Experts,

       

      This is a simple fuction we are trying to have custom color in our chart based on the metric selected. (like Metric =ABC Red etc)

      used in a linear gauge insde a straight table.

       

      This below code is not giving the different colors as desired.

       

      if(Metric='ABC',ARGB(191,3,184,91),if(Metric='XYZ',ARGB(242,242,188,102),if(Metric='MNP',ARGB(241,166,192,241),if(Metric='WHO',ARGB(217,217,151,163),if(Metric='FNP',ARGB(244,244,155,69))))))

       

       

      Please help.

       

      Regards,

      Roy