Line chart is not displaying percentages correctly on Y axis
I created a row report which displays each team members' allocation % each month. I want this represented by a line chart with each line representing a team member, plotting their allocation percentage each month. I created a line chart, and the lines for each team member are being plotted correctly, and when I hover over time points it shows the correct percentages. However, the Y axis is not displaying percentages. Any advice?
Answers
-
Hello @sewalta,
In the source Sheet that is being referenced by by your report, are the column completely formatted as a %?
I would check that (click the column name so the entire column is selected then click % to format it as such).
If that does not work, can you send screenshots of your expanded report and source Sheet? That will help diagnose this more accurately.
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
-
Here is a screenshot of the source sheet showing that all the columns are formatted as a % and here is a screenshot of the expanded report.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives