Label numerical values in listboxes, charts

[#1]

Hi, all:

Is there a simple way to label numerical data for listboxes and charts? For instance, in my data, I have values 1,2,3,4, etc. that represent different categories (Sales, Revenue, etc.). I want list boxes to show text description rather than the (unhelpful) numbers.

Is there a quick way to label without reloading the data? Thanks,

Andrew

[MayilVahanan · Accepted solution]

HI

=Pick(WildMatch(FieldName,1,2,3,4),'Sales','Revenue','Net','Others')

[#3]

Thanks! Worked perfectly.