Is there a way to freeze the y axis on a graph in Smartsheet?
We have a survey graph on a program dashboard and I want to set and freeze the Y axis to a specific number (5) so it is easier to tell what the results are out of. I haven't been able to find a way to freeze/set the Y axis to a specific number… is this possible?
Answers
-
A workaround that works on some similar issues is to add an extra column of data that is slightly larger and uniform across different graphs that forces the scale to adjust and then manually make that column of data graph in white to make it not visible.
I've used this before to force a uniform y axis on 5 scatter plots I wanted to allow visual comparisons before - to each one I added a "min" and "max" column where each row pulled the minimum and maximum value from all 5 plots for that row. This forced the y axis to auto scale to the same level across all 5 graphs to make differences more visible.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 433 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives