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?



  • BullandKhmer
    BullandKhmer ✭✭✭✭✭


    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.

  • Jeff_Berman
    Jeff_Berman ✭✭✭✭

    @BullandKhmer Thank you for the response. I understand your feedback and appreciate you taking the time to answer this question.

    Thanks again!