HOW TO SHOW DATA ON A PIE CHART USING VALUES IN TEXT FORMAT AS LABELS

I am trying to show data on a pie chart in a dashboard, but I am getting messed up.


The source data are taken from a table in a report:

-data values are in the left column (format: numbers)

-data labels are in the right column (format: text) 


I need the pie chart to source the data from the left column and use the values from the right column as labels. Easy and simple, apparently.


There comes the problem:


-If I select only the left column, the pie chart is available, but the labels are missing.

-If I select also the right column, the pie chart is no more available and I am forced to use a bar chart.


Where did I go wrong? How can I fix this?


Best Answer

Answers