Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
how to change chart widget axis scales
Victor Wang
✭✭
Hi,
I am just wondering if the axis scales values can be changed to fixed values instead of dynamics as it is right now.
I would like the vertical axis range values to be set to 0-100% for my below graph:
Thanks.
Victor
Best Answer
Answers
-
The only way to get the axis data to change is to either change the size of the widget and/or change the source data.
-
thanks, Paul.
-
Have a column in your counts sheet that says 100%.
Add that column to your chart as a reference, then in the Series bit in the edit, change its colour to white (or whatever your background colour is)
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.3K Get Help
- 462 Global Discussions
- 156 Industry Talk
- 508 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 518 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- I am using Smartsheets to gather data and send out mass messages. How do I send out sheets to a mass group without just texting out the link? Is there a easy way to send out forms via SMS and Email? I…
- I have a sheet and the primary column cells are hyperlinked to specific SharePoint documents. It works well for use with Dynamic View, etc. However, when trying to sort by this column it sorts by the …
- I have a form with a question that has three restricted dropdown values. I only want 2 of those values to show on the form but on the sheet it populates to, I want a third restricted option available …
