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
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives