Line Chart Widget on Dashboard
I am trying to graph two sets of information.
One data set that I want displayed as a flat line as drawn in the screenshot below.
The other data set will be the actual result which I would like displayed as a data point (again displayed in the screenshot).
I have also included a screenshot of the source data for reference. I have 2 columns / mo. One column is the actual and the other column is the 100% for each month.
Is this possible?
Answers
-
Hi,
First of all, I do not believe this is possible, I'm pretty sure SS doesn't allow line +scatter diagrams. The best you can do to my knowledge is two lines In your case a straight line and another variable line.
To build the two line graph you will need to build a metric sheet with two rows "Projected" and "Actual" or similar. Add columns for each month and use formulas to populate the rows, then build your line chart off this sheet.
Let me know if you need more help.
-
@BullandKhmer Thank you for the response. I understand your feedback and appreciate you taking the time to answer this question.
Thanks again!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 135 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 36 Webinars
- 7.3K Forum Archives