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
