Donut chart to display comma separated values in column

[shaunguyver]

I have a table that contains the following columns:

Column A - Name

Column B - Region

Column C - Skill Set

In column C, more than one skill can be attributed to the individual. For example one record could read 'project management', another could read 'project management, stakeholder management', and another could read 'stakeholder management, data analysis, Excel.'

Is there a way to create a donut chart to display all distinct comma separated values in Column C, so that each possible skill is displayed? So far, I can only get a donut chart to display every combination that appears.

Thanks

[Anonymous · Accepted solution]

Hi @shaunguyver,

Maybe you can add calculated column with CONCATENATEX function to manually summary project names with comma, then use this column as category of donut chart.

Regards,

Xiaoxin Sheng