Stacked column chart numbers are overlapping
Hi community,
I have this stacked column chart on a dashboard but some of the value labels in 2023, 2021, and 2020 are overlapping and difficult to read and there is no option to change the font size or position of the value labels. How can I make this more legible? I don't want to make the chart a different size.
Thank you in advance for any help or suggestions.
Best Answers
-
Unfortunately the only way currently is to adjust the chart size or remove the labels entirely.
-
Hi @LizTo
Dashboards are being reviewed as a whole this year - you can follow along and receive updates from this Product Idea thread: Dashboard Improvement
However that's a general idea thread with a general update from the Product team. In regards to this specific request, adjusting values, I would recommend voting on this individual Idea post, here: Chart Labels: drag labels overlap & stacked column labels
Answers
-
Unfortunately the only way currently is to adjust the chart size or remove the labels entirely.
-
@Paul Newcome I was afraid that was going to be the case. Thanks for taking the time to reply and confirm.
-
Commenting to share that I have this problem too-and I hate it. Short of making a chart the size of an 8.5x11 sheet of paper, numbers consistently overlap. Values labels within the chart should scale with the size of the chart. Period. Please don't ask the end-user to fiddle with chart sizes to find the "perfect" view to resolve this problem.
-
@Susan L. I hear you!
@Genevieve P. Is this in the works to be addressed?
-
Hi @LizTo
Dashboards are being reviewed as a whole this year - you can follow along and receive updates from this Product Idea thread: Dashboard Improvement
However that's a general idea thread with a general update from the Product team. In regards to this specific request, adjusting values, I would recommend voting on this individual Idea post, here: Chart Labels: drag labels overlap & stacked column labels
-
@Genevieve P. Thanks, I'll take a look at those posts now! Glad to know this is already being discussed and I look forward to seeing the dashboard improvements in the future!
-
@Genevieve P. We also need this to be fixed. It is preferred to have labels inside the bars for stacked bar charts, and options in general for series labels. We have a >10-stage process and are using the stacked bar chart to demonstrate % completion for each stage. In case it is helpful, we see label overlaps if a previous stage is 100% complete and subsequent stages are <50% complete. I am not able to expand the chart wider to minimize the overlaps due to the set dashboard width.
Also, I look forward to being notified of the coming improvements, but your Product Idea thread "Dashboard Improvement" link doesn't appear to work.
-
Hi @Paula King
Thanks for letting me know the URL does't connect! Here's the updated link: https://community.smartsheet.com/discussion/96291/dashboard-improvement/p1
You can also find this in the Product Ideas topic linked in the header bar of the Community.
For your specific request, it would be helpful if you could add your screen capture and explanation to the other Idea thread so the feedback can be bubbled up to the Product team:
Thank you!
Genevieve
Help Article Resources
Categories
Check out the Formula Handbook template!
