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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives