Simple renaming of data labels in legend

[Anonymous]

Hi all,

I created a 100% stacked chart below, and it is split by a legend named "Filled". I am trying to rename the 2 series,

• Rename 'Y' to 'Yes'
• Rename (Blank) to 'No'

How should I go about doing this? Thank you.

[amitchandak]

@Anonymous , You have create a new column

Switch(True() ,

isblank([column])= "No",

[Column]= "Y", "Yes"

)

[Anonymous]

Hi amitchandak,

Thanks for the swift response. Just wondering if there is any other workaround besides having to create a new column?

Thank you.