How to create a pie chart based on alpha numeric values ?

[#1]

i am sharing the source data column and expected pie chart, any idea how to create it ?

thanks.

[#2]

ohh, got it.

i did what you said for the % but still its not working.

[MK_QSL]

Provide sample data please !

[#4]

PFA

[#5]

any idea how to divide that column into two ?

[MK_QSL · Accepted solution]

CHECK enclosed file...

[#7]

Perfect !! Thanks a lot Manish.

so it isnt necessary to separate the column into two columns ?