Plotting Time on Y axis
Hello,
I am trying to plot how a plan finish date changes over time. I have tried to graph this in smartsheet but I keep getting an error. Overall, I am attempting to have a graph similar to what I have plotted in excel (the X axis being the week recorded and Y axis being the plan finish date shown for that week)
The table I have is formatted like this which is what I am trying to replicate in smart sheet. Any ideas for plotting this?
Answers
-
Hi @lgood
There currently isn't a way to use Dates as values to map on a graph; you would need to have some sort of numerical data in order for the chart to know where to place the line.
Instead of using Dates, what about using the number of days since the project started?
For example, if you had the original Finish Date, you could then see the days between the original finish date and the next dates listed:
The formula for each Week column is simply the [Week 1 Date]@row - [Original End Date]@row
This will create a number. Then you can use the number portion of this data to create charts:
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