Data labels in chart widget
What can I do so the data labels don't overlap, in the image above the 0% is overlapping with the 17% in Feb?
Answers
-
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).
-
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?
-
Have you looked at the regular bar instead of stacked bar?
-
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.
-
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]))
-
Thank you Paul great idea!
-
Happy to help. 👍️
-
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
-
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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
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
-
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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!