Line chart widget is only showing dots

Options

I am new to creating dashboards in smart sheets. I am having an issue with the chart widget. I am trying to do a line chart and all I get is dots. What am I doing wrong?


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓
    Options

    To get additional lines you are going to need to build out the table. Which way you go is going to depend on exactly how you currently have your data structured and widget set up.


    I imagine you have something like the months in one column and the counts in another column sort of like this:

    Jan.....16

    Feb.....32

    Mar.....48

    so on and so forth.


    To include another line, you would have those counts in another column

    Jan.....16.....10

    Feb.....32.....18

    Mar.....48.....25


    Then include all columns in the chart.

Answers