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
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives