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
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives