Chart Labels: drag labels overlap & stacked column labels

David Tepper

https://community.smartsheet.com/discussion/comment/377873#Comment_377873

I have business stakeholders who are misunderstanding charts because of this limitation. I need a way to configure labels such that they are superimposed on top of the segment (bar or column) of the data that they pertain to, not above it or to the side of it. That's confusing to have the label be outside the box it is referring to. Please address this! Thanks, David

LaurieCass

Agree with previous members, need a solution to the stacked chart labels.

Ravi D.

Hello,

The show value labels on charts, particularly stacked column charts, sometimes cause problems because of their placement at the top of the columns. Unless closely examined, this placement can cause users to interpret the value for the lower label as denoting the value of the label in which it appears, and in some cases, the value labels for the top column have been observed to be truncated. It would be helpful to be able to control the placement of these value labels in relation to the column, or at least to be placed in the middle of the corresponding column, instead of at the top.

Brianhl

Smartsheet please address this. Correct placement and interpretation of data labels is fundamental. Your stacked bar and column graphs as not useable for executive audiences. It would be good to not have to export data out of Smartsheet to use other dashboarding solutions.

Jake Gustafson

Excited to have enhanced functionality here. I've got a chart that cuts off the numbers and it continues to do the same if I make the widget full width or add the legend on the right. Can't tell the whole story with this.

Any update on timing?

Gilopez

SmartSheet Support Team,

I'm writing to suggest a feature enhancement that would greatly benefit users like myself who rely on SmartSheet for reporting and data visualization purposes.

Feature Request: Enable the ability to edit where a data label is placed in reporting.

Currently, while working with charts and graphs in SmartSheet, the placement of data labels is automatically determined by the system. However, it would be immensely beneficial to have the option to customize the placement of these data labels according to our specific reporting needs.

Use Case: In various reporting scenarios, the ability to control the positioning of data labels can significantly enhance the clarity and effectiveness of the presented data. For instance, in a bar chart comparing sales figures for different regions, users may prefer to display the data labels directly above each bar for easy reference. In contrast, in a pie chart representing market share, placing data labels inside the corresponding segments could provide a cleaner presentation.

Proposed Solution:

Implement a feature within SmartSheet's chart customization options that allows users to manually adjust the placement of data labels. This could include options to position labels above, below, inside, or outside of data points, as well as the ability to freely drag labels to desired locations within the chart.

Thank you for considering this feature request. I believe that implementing customizable data label placement in reporting would significantly enhance the functionality and usability of SmartSheet for a wide range of users.

Please feel free to reach out if you require further clarification or additional information regarding this request. I

look forward to hearing your feedback on the feasibility and potential timeline for implementing this feature.

Technical Project Manager

Gigi Lopez

Nina R

Can you add to the functionality the ability to select the placement of where the numbers for each stack appear? Right now, they only appear above, and it is confusing

miwalker

Yes, please support moving the value inside the bar on the chart. For a "Stacked Column" chart, the label is confusing in it's location "on top". I have to turn off the label or people get confused, and when needed I end up rebuilding it in Excel instead.

torishriver

This issue still is at large :( we cannot present our graphs to our clients because of how awful they look! I'm really disappointed with Smartsheet's dashboard capabilities and have started using Power BI for their great interfaces. How Smartsheet gets away with not fixing these awful looking graphs that have no clear labeling and blatantly overlap each other is beyond me.

subhadrav

See the attached screenshot.

The label value displayed in a stacked bar chart is misleading as it is displayed outside each bar. But on the visual, it feels as if the value on each stack is the right value, but it is the one outside each stack is the right value. Can the value be inside each stack for their corresponding stack?

Screenshot 2024-07-23 133923.png

reneeand_OHS

It might be cleaner to omit the 0's and put the number inside the pertaining colored bar graph instead of outside of it. The numbers are getting mashed together and are unreadable.

Shashank

Dear Team, first I would like to appreciate the team who build the highly user-friendly product, secondly, I would like to acknowledge the team who give the opportunity to submit ideas and feedback.

I would like to submit a suggestion on the Staked bar graph, the numbers appearing are confusing as it appears on top of next bar. please think some other way to display it. ref print screen for details.

FranciscoLl

Currently if you need to compare different sets of data in a bar graph, the labels overlap

cmart

Figured I would add to this discussion showcasing the problems that it is causing for us. Additionally, if you have a "0", it will show the 0 inside one of the other numbers making that number unreadable. The solution I found was for my formulas to check for a 0 and leave that value blank—but this is not optimal.

Susan L.

I'm frustrated that this is still unresolved. I've asked previously for this issue to be addressed. It matters to our team and, our clients, that our data be easy to understand and interpret. This issues, along with an inability to suppress zeros, or create charts with multiple axis/chart types (bar chart with overlying line graph) make our reporting look amateurish and unprofessional. There are many good things within Smartsheet, but, this is not one of them.