Line chart widget is only showing dots
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
-
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
-
Your horizontal axis needs more data points. Are you planning on plotting some kind of trend, or are you just showing those three pieces? If you are just showing those three pieces then you may want to consider a column/stacked column or bar/stacked bar graph type instead.
-
Paul I am trying to show a projection for the whole year. So those numbers would be the numbers we want to achieve by year end 2022.
-
Are you wanting to show actual in comparison to the projected, or are they the only data points you want displayed? Are you wanting monthly breakdowns growing cumulatively as the year progresses? If you are wanting monthly points, then you would need to enter each month onto its own row to have those points plotted.
-
Hi Paul thank you for your help. I broke down the numbers I had into months and those are now on there and it looks good. Is there a way to get more than one line on the graph. I am now getting something that looks like this but I need three different lines on it to show the different totals.
-
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.
-
That is great thank you for your help!
-
