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
-
Try swapping the columns.
Answers
-
Try swapping the columns.
-
Yep, it works correctly now. Thank you!
-
Excellent. Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives