Charts - Value over Time
I am trying to create a chart which displays a contingency fund remaining balance over time. Here is what I was able to produce:
This looks great, but the x-axis(time) is not to scale. I am pulling from a sheet that contains all instances of contingency fund draws, but they will not occur at a regular interval. Is there any way for the chart to adjust the x-axis scale based on date, so I can get a more accurate representation of the fund over time?
Best Answer
-
Hi @coryg
This chart looks great! The way you have it set up is the only way that chart widgets are able to recognize dates in the x-axis. Essentially it sees the Date Column more like a Text Column, bringing over the dates as text labels.
This means that you can't currently configure chart widgets to recognize a date column and spread out the values according to the days between. You would need to have each day/date listed in your sheet so the chart can recognize the data pulled into it.
Please submit an Enhancement Request to let our Product team know about your feature suggestion!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
Hi @coryg
This chart looks great! The way you have it set up is the only way that chart widgets are able to recognize dates in the x-axis. Essentially it sees the Date Column more like a Text Column, bringing over the dates as text labels.
This means that you can't currently configure chart widgets to recognize a date column and spread out the values according to the days between. You would need to have each day/date listed in your sheet so the chart can recognize the data pulled into it.
Please submit an Enhancement Request to let our Product team know about your feature suggestion!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives