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

AB consulting · 07/19/21

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?

Paul Newcome · 07/19/21

Try swapping the columns.

Paul Newcome · 07/19/21

Try swapping the columns.

AB consulting · 07/19/21

Yep, it works correctly now. Thank you!

Paul Newcome · 07/20/21

Excellent. Happy to help. 👍️

Best Answer