Multi Line Graph (Planned and Actual) with Trend Line
Hello I am looking for help in building a graph on a dashboard with multi lines (Planned and Actuals) tracking to a trend line and beyond. I have included an example below from Excel for reference. Any help you can provide would be appreciated.
Answers
-
Here's how I would structure the Metric sheet:
As long as your Planned and Actuals are in separate columns, you'll be able to map them as lines across your dates, like so:
There currently isn't a way to add the vertical purple line in your graph to the chart, but you could add a third column with a value across two dates and then fill in that line:
Let me know if that makes sense and will work for you!
Cheers,
Genevieve
-
Thank you soooo much. This is exactly what I needed.
-
How do you make the X axis in month day, YYYY ?
Is there a formula for you to point at a date column and change it from 3/4/2023 to March 4 2023?
-
Hi @messierr
In the images above, I just had the Date column formatted a specific way in the sheet and it translated into the graph as well:
See: Apply Standardized Date Formats in Your Sheet
Cheers,
Genevieve
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives