Dashboard Charts

Shawn Clemmons · 08/05/22

I have developed a line chart that shows the monthly percentage values. The chart seems to be working fine, but one thing I've noticed is that in some instances it will display one or multiple numbers more than once. For example, the percentage values range from 97% to 99%. The line chart will show two tick marks for each number, 97, 98, and 99. In my chart two months back-to-back are at 97% and the line chart shows them both at 97% when you hover over the month but the display shows one is closer to 98%. I would expect that 97% should be a level line and not show an incline. I am attaching a screenshot to help show the other issue of duplicative line indicators too. Any help is appreciated.

Paul Newcome · 08/05/22

It is because of the size of the widget vs the scale of the data. If your data had a larger range of numbers or the widget was smaller then it would not show those duplicated values on the vertical axis.

Paul Newcome · 08/05/22

It is because of the size of the widget vs the scale of the data. If your data had a larger range of numbers or the widget was smaller then it would not show those duplicated values on the vertical axis.

Shawn Clemmons · 08/05/22

https://community.smartsheet.com/discussion/comment/338816#Comment_338816

I did notice that too when I was scaling the widget. Unfortunately, I want the graph to be rather large for visibility purposes. That's a bummer. Thanks for your insight as always.

Paul Newcome · 08/05/22

You could add data to your source that has manually entered numbers covering a broader range. Include this as a second line in your chart and set the line color (series) to white.

Dashboard Charts

Best Answer

Answers

Categories