Data labels in chart widget

MichelleBohn

What can I do so the data labels don't overlap, in the image above the 0% is overlapping with the 17% in Feb?

Paul Newcome

The only thing would be to be selective of which data labels are shown. You can either adjust this in the widget settings or you can adjust your metrics sheet(s).

MichelleBohn

Okay, thanks Paul trying to keep all locations charts the same with both Involuntary / Voluntary on the same chart, do you have a better way of displaying this information?

Paul Newcome

Have you looked at the regular bar instead of stacked bar?

MichelleBohn

Yes, thank you I liked the stacked graph because then it shows then the total Employee Turnover for that month. Thanks for your help though.

Paul Newcome

It looks like even 1% is enough to keep it from overlapping too much. You could adjust your formulas in your metrics sheets to just not display anything that is 0%.

=IF(original_formula > 0, original_formula)

So if your original formula was a basic SUM (for sake of an easy example)

=SUM([Column Name]:[Column Name])

and you wanted it to only display if the sum was greater than zero so that if it did equal zero it was blank, you would have something that looks like this:

=IF(original_formula > 0, original_formula)

=IF(SUM([Column Name]:[Column Name]) > 0, SUM([Column Name]:[Column Name]))

MichelleBohn

Thank you Paul great idea!

Paul Newcome

Happy to help. 👍️

IPC

Hello @Paul Newcome, I am searching for an answer of the same issue.

In my case it's a project planned % vs actual. Apart from resolving the overlap issue, the fonts are also not adjustable. Any solution?

thanks in advance.

Irene

Genevieve P.

Hi @IPC

Since your numbers are so close together, I would personally suggest adjusting the size of your Chart Widget. Try making it thinner and taller until the numbers are more distinct. You may also want to use the Fill Line option for the "Actual" to show the difference between the two.

Cheers,

Genevieve

IPC

Hi @Genevieve P.

Thanks for the reply. Yeah i did that. However, adjusting the size is actually a workaround. If there is a specific location and size of each graph as per a designed dashboard, then it will distort the dashboard format.

I believe the @SmartSheet Admin @Shartsheet should look at ways to enable the dragging of the Data label (like excel).

Thanks again.

Irene

Genevieve P.

Hi @IPC

Thank you for your feedback on Chart Widget labels! If you would like the Smartsheet Product team to hear your suggestion, please submit your feature request by creating an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community. This will allow other users to vote on your enhancement idea and the top-voted feature requests are reviewed monthly.

Cheers,

Genevieve

IPC

Hi @Genevieve P.

This is great! I've been looking for that info where I can suggest improvement opportunity. I have been receiving this same inquiries to my new Smartsheet owners, or during the training for new users i already include it as "limitation in chart labelling." I will post, and hope to receive high votes in order to improve this.

Thanks a lot.

Irene